SUM range of cells that have INVALID DATA TYPE
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?
Help Article Resources
Check out the Formula Handbook template!