Forum Discussion
Do not count zeros
| 16-May | 20-Jun | 11-Jul | 22-Aug | 5-Sep | Aggregate | |||||||||||||||||||||||||
| Lname | Fname | Gross Score | HCP | Net Score1 | DQ = x | Gross Score | HCP | Net Score2 | DQ = x | Gross Score | HCP | Net Score3 | DQ = x | Gross Score | HCP | Net Score4 | DQ = x | Gross Score | HCP | Net Score5 | DQ = x | Total Gross Score | HCP | Total Net Score | Five Games Played? | |||||
| Player | One | 100 | 20 | 80 | 0 | 0 | 0 | 0 | 100 | 20 | 80 | 0 | 100 | 20 | 80 | 0 | 0 | 0 | 300 | 60 | 240 | 5 |
The above is a golf competition for each month of the golf season. See last column - 5 games played?. This total is counting zeros in the "net score" columns. How do I NOT count zeros in these columns? I've spent an hour trying to figure this out. What is the formula please?
You may use something like
=COUNTIFS(C2:Z2,"Net*",C3:Z3,">0")
and attached
