Ronnie1979
New Member
- Joined
- Jan 27, 2018
- Messages
- 3
I am trying to count the number of cells in a range with data in consecutive cells. The data may not match in each cell, i just need to count consecutive cells with data. If there is a blank cell between the consecutive data cells it should not be counted. Below are some examples.
<tbody>
</tbody>
1/15/18 | 1/16/18 | 1/17/18 | 1/18/18 | 1/19/18 | Results |
NS | <30 Late | >30 Late | 1 | ||
NS | NS | NS | 1 | ||
NS | NS | NS | 0 |
<tbody>
</tbody>