Formula to count a value in column that was one week ago from today

[mgf23]

Howdy All,

I have 2 columns in my spreadsheet:

B:B is a column of dates.
C:C is a list of names

Could someone suggest a formula that will count the number of times the name 'SIMON' appears in column C:C but here is the catch: I only want to know how many times that name has appeared over the course of the previous week. IE NOW - 7days

any help really appreciated.

[daddylonglegs]

Try using SUMPRODUCT like this

=SUMPRODUCT((B2:B100>TODAY()-7)*(C2:C100="Simon"))

adjust ranges as required

[mgf23]

Thank you so much - worked a treat!