CountIf or sumproduct

T

timmulla

I need a countif or sumproduct formula that can count a number of values
based on a multiple criteria.

Count range: D:D column
Criteria: Count the number of cells that are greater than 0 and less than
200 in column H:H, that also have a the word "BUY" in coulmn B:B.

Any help would be appreciated.
 
R

Ragdyer

Unless you're using XL07, you can't use entire rows (B:B, H:H) in your
SumProduct formula.

Try this:

=SUMPRODUCT((B1:B1000="Buy")*(H1:H1000>0)*(H1:H1000<200)*(D1:D1000<>""))
 
Top