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

Options
edited 11/15/23

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

Tags:

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• Options

I could kiss you. Thank you.

• ✭✭✭✭✭✭
Options

Happy😚 to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!