Last 7 days

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.

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.