sheet summary, countifs task status

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")

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Do you have that error anywhere within the range?

All comments

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! 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.