=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

  • heyjay
    heyjay ✭✭✭✭✭
    Answer ✓
    Options
    =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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!