Count formula results are off by 1

I build a simple formula to count results in a column

=COUNT(Status:Status, "Open/Active")

When i fist made the formula it should have reported 4 but it said 5. I made sure that nothing was hidden or had white on white text and even deleted all the rows out . When all rows were deleted out the formula returned value of 1

Find more posts tagged with

Accepted answers

Mike Wilday

Cool, thanks for catching that. I just edited it. Can you mark it as the correct answer! Thanks. Glad I could be of help.

All comments

Mike Wilday

Try using =Countif(Status:Status, "Open/Active")

Mike Wilday

Can you send a screenshot of test data that mimics what you have setup? That will help as well.

Randy Van Winkle

You had a period instead of a comma after Status, but otherwise it worked

Mike Wilday

Cool, thanks for catching that. I just edited it. Can you mark it as the correct answer! Thanks. Glad I could be of help.

Randy Van Winkle

Done! thanks

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.