How can I use countifs to sort Modified date?

audrey.hart

I am trying to create a dashboard to help me sort through our companies updates in emergencies, which they will submit through a form. Each section has a symbol of red, yellow, green, gray. I have the formula to summarize them by section. I am looking to pull how many reds based on time now. Since some incidents may occur & last more than 24 hours and Exec will want daily reports to summarize I am trying to create a formula to only pull the symbols within the last 24hours.

I am very new to this but this is what I have right now for a formula

=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, AND>=TODAY(-1))

Julie Fortney

So close! Just remove the "AND" from your formula:

=COUNTIFS({Activation Updates Range 1}, "red":{Activation Updates Range 11}, >=TODAY(-1))

audrey.hart

It's still telling me unparseable?

Paul Newcome

Try this:

=COUNTIFS({Activation Updates Range 1}, "Red", {Activation Updates Range 11}, >=TODAY(-1))

The colon before the second range needs to be a comma.

audrey.hart

Thank you that worked! Any idea if it's a day from the date or 24 hours?

Paul Newcome

It is strictly date based, so any submissions that have a date stamp of yesterday's date.