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!