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 Sc...
You may use something like
=COUNTIFS(C2:Z2,"Net*",C3:Z3,">0")
and attached