COUNTIF is Not Working as a Sheet Summary Field

scottreiter

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.

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.

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.