even after adding the second quote mark around jw, (you are starting to type
like I do) I still get an #value error using your equation
I can do either section and get an answer, but not in the format you have it.
when I use
=SUMPRODUCT((H1:H10020)*(C1:C1002={"jw","wh","br" ,"sm"})),
which should be identical, I get the right answer
I have 2003
does anyone else have this problem?


"Roger Govier" wrote:

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.