sum of values in an entire workbook

[Guest]

I want to know how to get the sum of values in column "I" in every sheet in the workbook except the final sheet when the corresponding cell in column "C" date falls in "May 04

Any help would be great!

Kim

 

[Frank Kabel]

Hi
some solutions:
1. Harlan Grove showed a formula approach for a
conditional sum accross
multiple worksheets. Have a look at this thread
http://tinyurl.com/2manj

2. You may also try to download the free add-in
Morefunc.xll
(http://longre.free.fr/english). The function THREED
converts a 3D
array to a 2D array. e.g. you may use the following formula
=SUM((THREED('sheet1:sheet10'!C1:C1000)>=DATE(2004,5,1))*
(THREED('sheet1:sheet10'!C1:C1000)<DATE(2004,6,1))*(THREED
('sheet1:sheet10'!I1:I1000)))

enter this as array formula (CTRL+SHIFT+ENTER). This will
sum all
values from column I in which column C contains our
criteria

-----Original Message-----
I want to know how to get the sum of values in column "I"

in every sheet in the workbook except the final sheet when
the corresponding cell in column "C" date falls in "May 04"