=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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!