Two conditions in a SUMIF

  • Thread starter Thread starter n8v_nerd
  • Start date Start date
N

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)
 
Hi SUMPRODUCT dos not accept suh ranges. Of course you
could use
B1:B65535
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Sumif 1
Multiple Sumif conditions 2
Two conditions in a SUMIF 1
Conditional Format a dynamic list in Excel 2007 1
How to intersect two coloumns in a third coloumns 3
Sorting in one tabs messes up formulas in another tab 3
To me this is huge, need some assistance 1

Back
Top