Unable to SUM column totals that include "#No Match" cells?
Please help me understand why my formula isn’t working. I am trying to sum and average the total of a column containing serval #NOMATCH cells. I have tried two different formulas that return the following results.
=IFERROR(SUM([Year 1 Cost]:[Year 1 Cost]), "") Returns blank cell
=IFERROR(SUM(AVG([Year 1 Cost]:[Year 1 Cost]), "") Returns #INCORRET ARGUMENT
Much appreciated,
Thanks!
Best Answers

That is correct.

Happy to help. 👍️
Answers

For any formula to work while referencing a column, the errors within the column must be removed.
Then you can use
SUM(range)
and
AVG(range)

Hi Paul,
I want to make sure I understand what you are saying. Are you suggesting that there is no way to ignore the #NOMATCH cells and calculate the remaining cells?

That is correct.

Thanks Paul..

Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!