Hi,

I don't believe sumif can be used on 3d ranges so another way would be to
place a sumif on each sheet then

=SUM(Sheet1:Sheet43!A1)

Which will sum a1 on sheets 1 to 43

Mike

"Fritzi" wrote:

am trying to get a sum for a particular item in a workbook. There are 43
sheets in the workbook. I was doing sumif and it says the formula is too long
and I was on sheet 40. Any ideas on how to get it to pull the info I need
from multiple sheets?