one possibility
=sumproduct(--(H1:H1000O1:O1000),--or(C1:C1000="jw",C1:C1000="wh",C1:C1000="br",C1:C1 000="sm"))


"Harley" wrote:

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.