Having trouble with pulling data with Countifs

David Rice

I am trying to get a table to count the amount of risks over the last 30 days with either critical, high, medium, and low. I am trying the following:

=COUNTIFS({Project Findings Range 7}, [Risk Level 30]@row), {Project Findings Range 8}, ">=TODAY(-30)"}

Does anyone have any good tips?

Paul Newcome

Try this...

=COUNTIFS({Project Findings Range 7}, [Risk Level 30]@row, {Project Findings Range 8}, >=TODAY(-30))