Sum up values with #NO MATCH error

HI All,

Some of the cells that I want to sum up are a "#NO MATCH" which is fine as those values are based on other formulas and there might be no value for them.

Now, trying =SUM(IFERROR(Cellsrange,0)) is not working, its giving me "0" as a result which is incorrect.- see attached.

Please help as its really painful doing this manually, knowing that those values might change..





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!