单独Excel表格中的具体数据总和 [英] Sum of specific data in separate Excel sheets
问题描述
我有两个单独的表格中有以下数据:
Sheet1 :
I have the following data in 2 separate sheets:
Sheet1:
A B C D
a ff dd ff ee
b 12 10 10 12
Sheet2:
A B C D
a ge ff ff ee
b 11 13 14 10
现在我想写一个公式来计算第2行中包含 ff
直接在上面(即第1行)
Now I want to write a formula to sum all the values in row 2 which contain ff
directly above (i.e. in row 1)
在我上面的例子中,我想添加(Cell Sheet1 [A,b],Sheet1 [C,b],Sheet2 [B,b],Sheet2 [C,b])等于49。
In my example above I want to add (Cell Sheet1[A, b], Sheet1[C, b], Sheet2[B, b], Sheet2[C, b]) which is equal to 49.
推荐答案
对于2张表,我会用brettdj的建议去,但是一般来说,你可以像这样执行多个工作表:
For 2 sheets I'd go with brettdj's suggestion, but, generically, you can perform SUMIF across multiple sheets like this:
= SUMPRODUCT SUMIF(INDIRECT( ' &安培; sheetlist&安培;'!A1:D1), FF,INDIRECT( ' &安培; sheetlist&安培;'!A2:D2)))
其中sheetlist是一个命名范围co保留所有表单名称
where sheetlist is a named range containing all the sheet names
这篇关于单独Excel表格中的具体数据总和的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!