Last 7 days

nicole.olson109101

I am trying to create a formula that will pull data from two columns in the sheet as follows:

Sheet columns include intakes by location and a date entered column. I want to create a roll up at the top to show intakes by location in the last 7 days that automatically updates.

Here is what I have:

=COUNTIF([Location:Location], "Main") AND ([Date],>TODAY(-7))

I'm not sure how to correct.

Paul Newcome

Try using a COUNTIFS like so...

=COUNTIFS(Location:Location, "Main", Date:Date, > TODAY(-7))

nicole.olson109101

It worked!!!! Thank you.

Paul Newcome

Happy to help! 👍️