Count of cells in the last 60 days with a specific status

Hi. I've been at this for hours and can't get it. I'm trying to write a formula that will pull a total count of items with a specific status for the last 60 days. Both of the formulas below work separately, but when I try to link them with an AND, it breaks. How do I link these two statements?

=COUNTIFS([Enablement Date]:[Enablement Date], >=TODAY(-60), [Enablement Date]:[Enablement Date], <=TODAY(0))

=COUNTIFS(Status:Status, "enabled and monitoring")

Find more posts tagged with

Countif

Accepted answers

jmyzk_cloudsmart_jp

@ebitterman

With the COUNTIFS function, you can concatenate any number of ranges and conditions.

COUNTIFS( range1, criterion1, range2, criterion2, range3, criterion3, range4, criterion4 ... ])

=COUNTIFS([Enablement Date]:[Enablement Date], >=TODAY(-60), [Enablement Date]:[Enablement Date], <=TODAY(0), Status:Status, "enabled and monitoring")

https://app.smartsheet.com/b/publish?EQBCT=e9d732db29974a46abf415051116d04b

All comments

jmyzk_cloudsmart_jp

@ebitterman

With the COUNTIFS function, you can concatenate any number of ranges and conditions.

COUNTIFS( range1, criterion1, range2, criterion2, range3, criterion3, range4, criterion4 ... ])

=COUNTIFS([Enablement Date]:[Enablement Date], >=TODAY(-60), [Enablement Date]:[Enablement Date], <=TODAY(0), Status:Status, "enabled and monitoring")

https://app.smartsheet.com/b/publish?EQBCT=e9d732db29974a46abf415051116d04b

ebitterman

I could kiss you. Thank you.

jmyzk_cloudsmart_jp

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.