Sumif Help

[Curtis]

I have a workbook with multiple worksheets (named 1401 thru 1491). In each of
these sheets and in the same cell (d254) is an identifier say the letter c. I
want to be able to look at this cell in all the sheets and if the cell
contains the letter c then I want to add the values in cell d256 (again in
each sheet)

Thanks

 

[Luke M]

Unforutnately, SUMIF is not a 3D supported function. What you could do is this:
In another cell, say D257:
IF(D254="c",D256,0)
Then create a 3D summation going through your new formula:
=SUM(1401:1491!D257)

 

[Domenic]

I have a workbook with multiple worksheets (named 1401 thru 1491). In each of
these sheets and in the same cell (d254) is an identifier say the letter c. I
want to be able to look at this cell in all the sheets and if the cell
contains the letter c then I want to add the values in cell d256 (again in
each sheet)

Thanks

Try...

=SUMPRODUCT(SUMIF(INDIRECT(ROW(INDIRECT("1401:1491"))&"!D254"),"C",INDIRE
CT(ROW(INDIRECT("1401:1491"))&"!D256")))

 

[Jacob Skaria]

Try the below formula. I would suggest to test this with small number of
sheets say 5.

--Make sure all sheet names are present..and valid (even spaces
between/after/before the sheet name will return error)

Try and feedback

=SUMPRODUCT(SUMIF(INDIRECT("'"& ROW(1401:1491) &"'!D254"),"c",INDIRECT("'"&
ROW(1401:1491) &"'!D256")))

If this post helps click Yes