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.