Metric Sheet Formula
Hi All,
I'm trying to write a formula to achieve the following:
In the source sheet: Check if the "Resource Type" column contains "Analytic/Data". If it does, it counts the occurrences where the "Deadline Health" column contains the value of the current cell in the "Description" column, otherwise, it returns an empty string. Any Ideas why this is not working?
=IF(CONTAINS({Resource Type}, "Analytic/Data"), COUNTIFS({Deadline Health}, CONTAINS({Description@row}, @cell)), "")
Thanks in advance!
Ashley
Best Answer
-
Use your countifs more directly.
=COUNTIFS({Resource Type},"Analytic/Data",{Deadline Health},Description@row)
Answers
-
Use your countifs more directly.
=COUNTIFS({Resource Type},"Analytic/Data",{Deadline Health},Description@row)
Help Article Resources
Categories
Check out the Formula Handbook template!