How do you sum totals of a column that include "No Match" cells?

Matt May

Hello,

I have been trying to search online but can't seem to find the answer to my question.

What is the formula to sum cells in a column that include some "No Match" cells?

Much appreciated,

Cheers

Andrée Starå

Hi Matt,

I’d recommend adding an IFERROR function to the formula that is showing the #NO MATCH.

Try something like this.

=IFERROR(FORMULA; "")

The same version but with the below changes for your and others convenience.

=IFERROR(FORMULA, "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

More info:

https://help.smartsheet.com/function/iferror

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Matt,

I’d recommend adding an IFERROR function to the formula that is showing the #NO MATCH.

Try something like this.

=IFERROR(FORMULA; "")

The same version but with the below changes for your and others convenience.

=IFERROR(FORMULA, "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

More info:

https://help.smartsheet.com/function/iferror

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!