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?

Find more posts tagged with

Accepted answers

All comments

ker9

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.