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