COUNTIFS always returns 0

I can't get my COUNTIFS equation to work, it always just returns 0, can anybody help?

=COUNTIFS([Column A]@row, "None", [Column B]@row, "None", [Column C]@row, "None", [Column D]@row, "None", [Column E]@row, "None", [Column F]@row, "None")

Find more posts tagged with

Formulas

Countif

Accepted answers

Protonsponge

Hello @Sarahh - Are you looking to count if "None" appears in any of the columns A-F? You formula as written will only count if "None" appears in Column A, B, C, D, E and F.

The following formula might work for you which sum the total if columns A-F equal "None"

=COUNTIF([Column A]@row, "None") + COUNTIF([Column B]@row, "None") + COUNTIF([Column C]@row, "None") + COUNTIF([Column D]@row, "None") + COUNTIF([Column D]@row, "None") + COUNTIF([Column E]@row, "None") + COUNTIF([Column F]@row, "None")

All seems to be working in the demo below,

I hope that is helpful to you in someway,

Protonspounge

All comments

Protonsponge

Hello @Sarahh - Are you looking to count if "None" appears in any of the columns A-F? You formula as written will only count if "None" appears in Column A, B, C, D, E and F.

The following formula might work for you which sum the total if columns A-F equal "None"

All seems to be working in the demo below,

I hope that is helpful to you in someway,

Protonspounge

Sarahh

It's worked thanks Protonspounge!

Sarah

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.