Sum up values with #NO MATCH error
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
Check out the Formula Handbook template!