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
|