So I have a List of all days in November and number of repairs. See below. The repair column is referencing data in cells on another sheet. a simple "='Production - November'!B8" formula. The cells that are blank are referencing a 0 from the other sheet. I have the data hidden using conditional formatting. I need to be able to count the number of cells that are currently displaying data. In this case, it would count 4 until I enter the repair numbers for "7-Nov".

Date Repairs
1-Nov 7
2-Nov 7
3-Nov 6
4-Nov 7
7-Nov
8-Nov
9-Nov
10-Nov
11-Nov
14-Nov
15-Nov
16-Nov
17-Nov
18-Nov
21-Nov
22-Nov
23-Nov
28-Nov
29-Nov
30-Nov


Is there an easy way to do this? I need to be able to get an average without doing anything other then adding the repairs for each day on another sheet.