Wishmaster89
Board Regular
- Joined
- Jan 10, 2022
- Messages
- 77
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hi
In the sample data I need to count the values that are "19/20" in column c unless a greater year is in column B e.g. row 4. If both columns match do not double count.
In the sample data I need to count the values that are "19/20" in column c unless a greater year is in column B e.g. row 4. If both columns match do not double count.
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | ID | year | year | ||
2 | 1 | n/a | 19/20 | ||
3 | 2 | n/a | 19/20 | ||
4 | 3 | 20/21 | 19/20 | ||
5 | 4 | n/a | 19/20 | ||
6 | 5 | 20/21 | 19/20 | ||
7 | 6 | 19/20 | 19/20 | ||
8 | 7 | n/a | 19/20 | ||
9 | 8 | 21/22 | 19/20 | ||
10 | 9 | 19/20 | 19/20 | ||
11 | 10 | 19/20 | 19/20 | ||
Sheet1 |