=SUM Formula that returns a Zero if cells are Zero

I'm trying to figure out how to get this formula to return a zero if the Age of Closed cases and the count of closed cases is both "0".

=IFERROR(SUM([Age of Closed Cases]@row, [Age of Active Cases]@row) / SUM([Count of Closed]@row, [Count of Active]@row), 0)

Both are derived from a =COUNTIF that uses a cross sheet reference to count the active and closed cases every month.

Find more posts tagged with

Accepted answers

heyjay

=IF(
AND(
    [Age of Closed Cases]@row = 0,
    [Count of Closed]@row = 0), 
   0,

IFERROR(
    SUM([Age of Closed Cases]@row, [Age of Active Cases]@row) / 
    SUM([Count of Closed]@row, [Count of Active]@row), 
  0))

William Gray

@heyjay at the moment it looks like it worked. I will be able to give a better response at the end of the month. Thank you for your help.

All comments

heyjay

=IF(
AND(
    [Age of Closed Cases]@row = 0,
    [Count of Closed]@row = 0), 
   0,

IFERROR(
    SUM([Age of Closed Cases]@row, [Age of Active Cases]@row) / 
    SUM([Count of Closed]@row, [Count of Active]@row), 
  0))

William Gray

@heyjay at the moment it looks like it worked. I will be able to give a better response at the end of the month. Thank you for your help.

William Gray

@heyjay thank you for your help on this formula. It worked as expected.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.