Countif when a cell in the row contains a date within the last 90 days

[FaithF]

I need to count all specific values in column B, only when column A contains a date within the last 90 days. Can anyone assist me with this?

 

[Legacy 143009]

Assuming dates are in column A and paste this formula to B2:

=COUNTIFS($B$8:$B$40,A2,$A$8:$A$40,TODAY()-90)

 

[FaithF]

Thank you for your help so quickly! This calculates as 0. In B2 I need to count the number of times "Bob" appears. In B3 I need to count the number of times "John" appears. And In B4 I need to count the number of times "Peter" appears.

 

[Legacy 143009]

Oh sorry. Infact the formula is right but checking the wrong date. Try

=COUNTIFS($B$8:$B$40,A2,$A$8:$A$40,">="&TODAY()-90)

 

[FaithF]

Oh sorry. Infact the formula is right but checking the wrong date. Try

=COUNTIFS($B$8:$B$40,A2,$A$8:$A$40,">="&TODAY()-90)

This worked perfectly! Thank you so much for your help!

 

[Legacy 143009]

Thanks for the feedback