Count = Serial Number Occurance within next 90 Days

[Kotakux]

Hi All,

I can't seem to figure out the formula for how to count the number of times an ID number appeared in the last 90 days of closure. Cells highlighted in yellow are what im looking for , but cant seem to workout the formula. Something to do with CountIFS ?

Kotakux

 

[Fluff]

How about

=COUNTIFS(A:A,A2,B:B,"<="&B2,B:B,">="&B2-90)

 

[Kotakux]

How about

=COUNTIFS(A:A,A2,B:B,"<="&B2,B:B,">="&B2-90)

Worked like a charm thank you mate!

 

[Fluff]

You're welcome & thanks for the feedback.