# =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.

• ✭✭✭✭✭
```=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))
```

...

@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.

• ✭✭✭✭✭
```=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))
```

...

@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 thank you for your help on this formula. It worked as expected.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!