IF('1'!B72,'1'!E2,0)

The logic of your formula is:

If '1'!B72 is *any* number other than 0 or, if it's a boolean TRUE, then
return the value of '1'!E2, otherwise, return 0.

So, the formula I suggested is doing a SUMIF across all the sheets like
this: (this syntax won't work)

=SUMIF(1:999!B72,"any number",1:999!E72)


--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
Im going to try what you have written there, but i don't understand any of
it, sorry!
But what I need is to find a way to do
IF('1'!B72,'1'!E2,0)+IF('2'!B72,'2'!E2,0)+...+('99 9'!B72,'999'!E2,0)
without
having to type that in for every sheet. So i need a sum of IF functions.
make more sense? Thanks, im going to try that formula you gave me, but if
i
would have to modify it i wouldn't know what to do... Thanks for you help
either way!

"T. Valko" wrote:

Do you understand my question?

Not really, but here's my best guess:

=SUMPRODUCT(SUMIF(INDIRECT("'"&ROW(INDIRECT("1:999 "))&"'!B72"),"<"&1E+307,INDIRECT("'"&ROW(INDIRECT( "1:999"))&"'!E72")))

--
Biff
Microsoft Excel MVP


"Jane" wrote in message
...
Ok, so i have 1 thru 999 worksheets and i need a sum of IF formulas.
But
SUMIF doesn't do what i need it to... I have IF('1'!B72,'1'!E2,0)
what
i
want is =SUM(IF('1'!B72,'1'!E2,0):IF('999'!B72,'999'!E2,0) ) but it
won't
let me do that. Do you understand my question?

Thanks!