Two conditions in a SUMIF

[n8v_nerd]

=SUMPRODUCT((INDIRECT(A2 & "!B2:B100")="HS")*(INDIRECT(A2
"!E2:E100")>0)*(INDIRECT(A2 & "!T2:T100")))

Sorry...guess I didn't need to bug you guys after all, but above ar
the solutions in case anyone else needs them...

Anyone know a way to make it so I don't have to stick down a stati
range(B2:B100), and can just have it the good ol' if it's ther
way(B:B)

 

[Frank Kabel]

Hi SUMPRODUCT dos not accept suh ranges. Of course you
could use
B1:B65535