am trying to get a sum for a particular item in a workbook. There are 43
M Mike H Oct 23, 2008 #2 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
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
P Peo Sjoblom Oct 23, 2008 #3 One way is you create a list with all the sheet names Assume list with sheet name is H1:H43 =SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H43&"'!A:A"),"X",INDIRECT("'"&H1:H43&"'!B:B"))) will sum B:B where A:A = X -- Regards, Peo Sjoblom
One way is you create a list with all the sheet names Assume list with sheet name is H1:H43 =SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H43&"'!A:A"),"X",INDIRECT("'"&H1:H43&"'!B:B"))) will sum B:B where A:A = X -- Regards, Peo Sjoblom
J John C Oct 23, 2008 #4 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.
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.
