SUM range of cells that have INVALID DATA TYPE
Hello,
I am trying to sum the range of cells, and some of them have INVALID DATA TYPE. I have tried the original formula here:
=SUM([Actual Days to Reach Milestone]74:[Actual Days to Reach Milestone]83)
And I tried adding IFERROR, but my answer just says 0 instead of counting the cells the that have the error as 0. The answer should come up with 384 if I count manually:
=IFERROR(SUM([Actual Days to Reach Milestone]74:[Actual Days to Reach Milestone]83), 0)
What is the correct formula for this?
Answers
-
Hi, @Frank Dean
I suggest first resolving the error in the Actual Days column. If it is a formula, preface it with =IFERROR(your formula, 0)
To move forward without fixing the error, add a helper column with the following formula in it. Make it a column formula.
=IFERROR([Actual Days to Reach Milestone]@row, 0)
This will return a 0 if there is an error. Then sum the helper column.
I dabbled in creating a SumIf with IsNumber formula but couldn't quickly arrive at a solution. Not sure if that will work on a column containing errors.
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!