=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.
Best 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.
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.
-
@heyjay thank you for your help on this formula. It worked as expected.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!