=SUM Formula that returns a Zero if cells are Zero

William Gray

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.

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.

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.