Count occurrences in the last 7 days.

[Tim2773]

Hi

Would anybody be able to help me with this Excel request.

I have two columns of data, A and B. In column A are dates of occurrence and in column B the unit it applies to, either A or B.

What i would like to do is have column C count the occurrences of either site A or B in the last 7 days based on whatever site (A or B) is listed in column B.

I have manually entered what I would like to appear in column C as an example. In the actual sheet there are several hundred sites not just A and B and the example uses 17/07/21 as today's date.

Is this possible?

Thanks
T.

[JohnTopley]

In C2

=IF($A2>=TODAY()-6,COUNTIFS($B$2:$B$23,$B2,$A$2:$A$23,">=" &TODAY()-6),0)

[Tim2773]

Thanks, worked perfect!