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..

Thanks,

Mia


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!