如题所述
=SUM(INDIRECT(ADDRESS(1,2,,,"sheet1")),INDIRECT(ADDRESS(1,2,,,"sheet2")),INDIRECT(ADDRESS(1,2,,,"sheet3")),INDIRECT(ADDRESS(1,2,,,"sheet4")))
如下图,工作表1~4同一位置求和工式
具体请下载例子