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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!