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

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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Curtis" wrote:

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 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
---------------
Jacob Skaria


"Curtis" wrote:

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

In article ,
Curtis wrote:

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")))

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions