sumproduct
Hi
Try
=SUMPRODUCT(--(H1:H10000),--(C1:C1000={"jw,"wh","br","sm"}))
Note you cannot use whole column references in Sumproduct.
Adjust range to suit.
--
Regards
Roger Govier
"Harley" wrote in message
...
I need to count the number of times column H is greater than 0, when column
C
= jw, wh, br or sm. Can't seem to work it out.
|