=SUM Formula that returns a Zero if cells are Zero
Options
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.
Best Answer

=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))
...
Answers

=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.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!