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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!