Count rows based on Date and Value criteria
I'm trying to count the rows in a sheet that have two criteria. I'm using the formula in a Sheet Summary field. The Date Initiated column cannot be blank and the Risk column is at High. Here is the formula I've tried with some variation:
=COUNTIFS(Rating:Rating, "High", [Date Initiated]:[Date Initiated], ISDATE@row)
All I get back are normal formula errors.
Help Article Resources
Check out the Formula Handbook template!