Chris Tucker
New Member
- Joined
- Jul 22, 2016
- Messages
- 6
I am needing a little help with something that is probably pretty basic. I need to know how many cells have a value based on a range of dates
<tbody>
</tbody>
Looking at the table above I need the values to show up in red. I need to search the date range A3:A12 and count the cells in row B that have values above the date in B1
Date | value after date | 1/3/16 | 1/10/16 | 1/17/16 | 1/24/16 | 1/31/16 | 2/7/16 | 2/14/16 | 2/21/16 | 2/28/16 | 3/6/16 |
1/22/16 | 3 | 1 | 21 | 6 | 8 | 2 | 3 | ||||
2/16/16 | 2 | 6 | 5 | 8 | 3 | 2 |
<tbody>
</tbody>
Looking at the table above I need the values to show up in red. I need to search the date range A3:A12 and count the cells in row B that have values above the date in B1