Fast Eddie
New Member
- Joined
- Nov 7, 2008
- Messages
- 5
Great site this, the knowledge people have is phenomenal. I've already searched for this question or something similar but couldn't find a solution. I have a sheet to analyze football(soccer) scores. But when I count the zero scores (no goals scored) across a range blank cells in the range are counted as zero, which I don't want. Is there any command I could put with the formula to tell it not to count blank cells as zero or just not to count blank cells at all? The sort of formula I use is {=COUNT(IF(H103:H559=0,(IF(I103:I559=0,1))))}