Formula Problem - Countif

[jennyp]

I want the spreadsheet to look down a column and if it finds the word "gold" go five columns along and if there is a numeric figure in that column (aligned with the word "gold") count it as 'one' entry. I have worked out the formula if I want to use the sum formula eg =sumif(E10:E118, "gold", J10:J119) however I also want to count the number of entries using only one formula. I know I can use =if($E10="Gold", Count (J10:J10),0) but it is counting per row by numerous row entries and I would prefer to use one formula that counts the column (similar to the sum formula). I hope this makes sense. Thanks for your help.

[richardreye]

I think you may want someting like this

=SUMPRODUCT(--(E10:E118="gold",--(ISNUMBER(J10:J118)))

Cheers!