COUNTIFS formula

Hello.

Please help!

I am attempting a formula where I would like to pull the number of 'Accomplishments' registered in a sheet in the 'last 7 days'. This is the formula I am using, but I am getting 'unparseable' -

=COUNTIFS({Type}, ="Accomplishment", AND {Date}, >= (TODAY (-7)))

Any help would be amazing.

Thank you

Find more posts tagged with

Formulas

Accepted answers

bcwilson.ca

@Nicole Jenner are you referencing the data from another sheet or from the same sheet? That would change the whole dynamic and explain the bracket change.

It wasn't clear in your first ask.. Try this..

COUNTIFS({Type}, "Accomplishment", {Date}, >=(Today(-7)))

as long as your ranges are selected properly and the {date} is a Date Field it should work.. Next step is I will have to create some test files

All comments

bcwilson.ca

Two things

1) Using COUNTIFS function, the AND is implied..

COUNTIFS([Type]:[Type], "Accomplishment", [Date]:[Date], >=(Today(-7)))

2) Remember you have to use a Range as in "[Type]:[Type]" instead of the Single Column "[Type]"

Let me know if that helps

Nicole Jenner

Thankyou for responding @bcwilson.ca.

I am still receiving unparseable. This is a copy of the formula based on your feedback -

=COUNTIFS({TYPE}:{TYPE}, "Accomplishment", {Date}:{Date}, >=(Today(-7)))

The only difference I see is the type of bracket/parentheses that is being used. This is being automatically put in when I select the reference, but even if I manually change the bracket type, I am still receiving the same result.

Any other suggestions?

bcwilson.ca

@Nicole Jenner are you referencing the data from another sheet or from the same sheet? That would change the whole dynamic and explain the bracket change.

It wasn't clear in your first ask.. Try this..

COUNTIFS({Type}, "Accomplishment", {Date}, >=(Today(-7)))

as long as your ranges are selected properly and the {date} is a Date Field it should work.. Next step is I will have to create some test files

Nicole Jenner

Thank you @bcwilson.ca. It worked!

Appreciate your assistance :)

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.