How do I combine AverageIF or CountIf with multiple Paramaters?

=AVERAGEIF((Priority:Priority="EMERGENCY", [Days to complete]:[Days to complete],>=TODAY(-30))

I would like to count or average the numbert of entries with an "Emergency" priority status from the last 30 days. How do I get my function to work?

I've tried this, but it always returns "0" which is incorrected:

=COUNTIFS(Priority:Priority, "EMERGENCY", [Date Complete]:[Date Complete], >=TODAY(-60))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!