Count values across two columns

[Wishmaster89]

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.

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

 

[ajitexcel]

Hello there, what do you mean? you want to count only values with n/a in column b, all other values are either greater than 19/20 or 19/20.