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

ebitterman

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")

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")

Smartsheet

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

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")

Smartsheet

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

ebitterman

I could kiss you. Thank you.

jmyzk_cloudsmart_jp

Happy😚 to help!