Unable to SUM column totals that include "#No Match" cells?

LeAndre P

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!

Paul Newcome

That is correct.

Paul Newcome

Happy to help. 👍️

Paul Newcome

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)

LeAndre P

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?

Paul Newcome

That is correct.

LeAndre P

Thanks Paul..

Paul Newcome

Happy to help. 👍️