COUNTIF is Not Working as a Sheet Summary Field

I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clearly are rows that meet the criteria.

SHEET SUMMARY FIELD FORMULA: =COUNTIF(Fund:Fund, 160)

Here is a sample of the data in my sheet that is showing rows in the Fund column that equal 160. The Fund column is defined as a Text/Number. It has a column formula that is an INDEX/MATCH to pull in data from a different sheet.

This problem is not just happening on this one column. It is happening if I use the COUNTIF against any column that has a column formula. The COUNTIF is working fine in the Sheet Summary if the column does not have a column formula.

Find more posts tagged with

Sheets

Formulas

Sheet Summary

Countif

Accepted answers

Michelle Choate 2

Hello @scottreiter

Down in your column, do you have some #NO MATCH's? Because if so, it is going to return #NO MATCH. If you wrap your fund column in an IFERROR statement, it should then return a count.

=IFERROR(Your current formula, 0)

That should solve your problem.

All comments

Michelle Choate 2

Hello @scottreiter

Down in your column, do you have some #NO MATCH's? Because if so, it is going to return #NO MATCH. If you wrap your fund column in an IFERROR statement, it should then return a count.

=IFERROR(Your current formula, 0)

That should solve your problem.

scottreiter

Thank you Michelle! Yes I looked thru the data and there was row in there that had a #NO MATCH. Updating the column formula with the IFERROR worked.

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.