Two conditions in a SUMIF

N

n8v_nerd

Ok...changed my little formula a bit, and it seems to be working more o
less, althouhg this makes it a little more static than I would hav
liked...

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

Apparently, SUMPRODUCT has issues with just a B:B type of reference
and you have to give it a known range..
 

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

Two conditions in a SUMIF 1
Help with Sumif and INDIRECT 9
How to compare a cell containing a date in sumif criteria 5
Two conditions in a SUMIF 0
make criteria in sumif refer to another cell 4
Indirect in combination with ROW 4
Sumif, having two condition 2
Working on birthday "book" for my wife and having layout/editing trouble 0

Top