AmateurHour
New Member
- Joined
- Jun 27, 2024
- Messages
- 4
- Office Version
- 365
- Platform
- MacOS
Hi All - New here so please bare with me.
I would like to count the number of times a cell containing "PB" would appear for a set individual between two dates.
For example in Image attached:
1. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and 13/1/24. (Result should be 1)
2. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and 30/1/24. (Result should be 3)
What formula would I use to achieve this?
Thanks in advance
I would like to count the number of times a cell containing "PB" would appear for a set individual between two dates.
For example in Image attached:
1. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and 13/1/24. (Result should be 1)
2. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and 30/1/24. (Result should be 3)
What formula would I use to achieve this?
Thanks in advance