CountIf or sumproduct
 

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.


--
Regards,

timmulla

CountIf or sumproduct
 

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:H10000)*(H1:H100 0<200)*(D1:D1000<""))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"timmulla" wrote in message
...
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.


--
Regards,

timmulla