Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Adding the sum of a range of cells using the IF function
Hi! I wonder if someone can help me. I have a range of cells using the IF function. I'd like to calculate that range using the SUM function in another cell, but it just comes back with the total as "0". Is there a special formula that I need to use to complete this action?
Thank you
Comments
-
Laurie,
Most of the time the reason why 0 appears in a SUM cell is that the range covered contains text-type entries (even if they seem to be numbers). For instance "23" is a text, while 23 is a number - you may have quotation marks in those IF() formulas that are not supposed to be there.
If it doesn't solve the problem, please give me an example of the IF() formulas you have.
Atus
-
You could also try using the SUMIF function to eliminate the need to have a separate column for the IF results, but this might not be what you are looking for.
-
Atus, thank you...that worked! I had quotes around the numbers.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives