Sum up values with #NO MATCH error
HI All,
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..
Thanks,
Mia
Answers
-
Hello @Smartsheet newbie MM
Would this work?
=IFERROR(SUM([Jun-23 \[h\]]429:[Jun-23 \[h\]]431), 0)
Peggy
-
Hi @Peggy Parchert, no it ended up in the same result- "0". See attached.
-
-
@Peggy Parchert yes its a formula that gets the values in if available. It's a month on month trend so some months have a value and others don't and the months that don't have come back as NO MATCH.
I am just wondering because the =sum(iferror.. works in excel..and i would have expected this to work in smartsheet as well, I don't think its so uncommon to happen.
-
Apologize for the delay. I would recommend that you add an IFERROR to the formula that is showing #NO MATCH in your screenshots making it show as "No Match". Reasoning is the #NO MATCH is set by SS and we do not know what value they are using to set it.
If you update the #NO MATCH formula, I believe =IFERROR(SUM([Jun-23 \[h\]]429:[Jun-23 \[h\]]431), 0) should work.
Peggy
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!