COUNTIFS WITH DATE RANGES

[ShaunF]

Hi,

Am having a brain fade. Am after a formula which returns the number (ie. count) of dates which are greater than a variable date , and where a unique identifier is met.

For example:

SHEET 1
A B
1 APPLE 10/10/2019
2 PEAR 10/05/2020
3 ORANGE 10/12/2019

SHEET 2
A B
1 APPLE 2/04/2020
2 APPLE 11/12/2019
3 PEAR 18/06/2020
4 PEAR 6/02/2020
5 PEAR 27/11/2019
6 PEAR 11/12/2019
7 ORANGE 1/10/2019
8 ORANGE 31/10/2019
9 ORANGE 9/01/2020
10 ORANGE 10/12/2019


I want to count the number of times a date shows in Sheet 2, which is greater or equal to the date in Sheet 1, where the fruit type matches. In this example, the return would be Apple - 2 ; Pear - 1 ; Orange - 3

In my sheets I have dates formatted as 'dates'.

Any help appreciated.

Thanks,

Shaun.

 

[mrshl9898]

Like this?

=COUNTIFS(Sheet2!A:A,A1,Sheet2!B:B,">"&B1)

 

[ShaunF]

Perfect. Thank you for the prompt response.