countif red text lines
Hi, want to count "at risk" check boxes to present at a dashboard.
so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result
Any suggestion
Thanks
0
Hi, want to count "at risk" check boxes to present at a dashboard.
so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result
Any suggestion
Thanks
Comments
Hi Andreas,
If you are using the Red Yellow Green symbol columns, you'll want to use this;
=COUNTIF([Status]2:[Status]14, "Red") - the capitalization matters.
If you are using a checkbox column, use this formula:
=COUNTIF([Status]2:[Status]14, 1)
Best,
Kara