If you have Longre's morefunc.xll installed (see
http://xcell05.free.fr/morefunc/english/index.htm )

There is a lot of useful functions, including adding 3D functions, that you
may find useful.


--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


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