SUMIFS with date: count within the last 7 days

Ryan Murphy

I'm looking to count the number of punches at various rec centers within the last 7 days. Rec centers have dropdowns with locations. Punches is a numeric value with a daily total. Each center has a daily total.

I have a separate sheet for calculations. I'm looking for a formula related to each center to count the number of punches within the last 7 days.

Any help appreciated!

Ryan Murphy

Found it! TODAY (-7))

Ryan Murphy

Found it! TODAY (-7))

Genevieve P.

Hi @rymurph

I'm glad you were able to sort it out! Thanks for posting your solution.