Greenies08
New Member
- Joined
- Apr 4, 2011
- Messages
- 22
Hi, I have data where by the row is dates and there are multiple columns underneath with data in.
I wish to count the number of times any entry is not blank for a whole month.
So for Nov, the answer would be 14, Dec would be 17
I used COUNTIFS(A2:A7,"<>""",INDEX(B2:H7,,MATCH(M4,B1:H1,0)),">0")
M4 is whatever month I put in on a separate cell
Thank you in advance
<colgroup><col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;">
<col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;">
<col width="51" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1865;" span="3">
<col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;" span="3">
<tbody>
</tbody>
I wish to count the number of times any entry is not blank for a whole month.
So for Nov, the answer would be 14, Dec would be 17
I used COUNTIFS(A2:A7,"<>""",INDEX(B2:H7,,MATCH(M4,B1:H1,0)),">0")
M4 is whatever month I put in on a separate cell
Thank you in advance
Primary Division | 26-Nov | 27-Nov | 28-Nov | 29-Nov | 03-Dec | 04-Dec | 05-Dec |
Motorsport | 4 | 4 | 4 | ||||
New Business | 9 | 6 | 13 | 16 | 20 | 50 | 9 |
Brewery | 16 | 19 | 9 | 12 | 25 | 17 | |
General | 3 | 4 | 6 | 15 | 12 | 4 | |
Equestrian | 3 | 6 | 7 | ||||
Motorsport | 0 | 0 | |||||
General | 1 | 7 | 0 | 2 | 1 | 9 | 18 |