sheet summary, countifs task status

Angela.R

I have a simple formula, i can't seem to get working. reads - invalid data type

In the sheet summary i want it to count the task status, (Red, Yellow, ...so forth) When i put in specific range ie [Task Status]2:[Task Status]100 - it seems to work fine. but when i wish to calculate the entire column.

(*some rows may be blank, but i assumed that didn't matter in this formula)

=COUNTIFS([Task Status]:[Task Status], "Red")

Paul Newcome

Do you have that error anywhere within the range?

Paul Newcome

Do you have that error anywhere within the range?

Angela.R

Doh!!! something so simple. I expanded all the rows and found there was an error on one of the rows within the range and fixed it. Which fixed my task status count. Thanks.

Paul Newcome

Happy to help! 👍️