Using SUM function on a column that has IF formulas in the cells
Hoping someone can help me with this issue! Please see the attached screenshot. I'm having this issue on 4 columns but will use the "Visit Metric" column as an example. I want to SUM the values of all the cells in that column within a cell at the bottom of the sheet, =sum([Visit Metric]2:[Visit Metric]114). However, when I do this I keep getting a calculation of 0 every time even though there are clearly 1's in that column. The IF formula in the Visit Metric column cells is =IF([DOV - Estimated DOV]2 > 31, "1", IF([DOV - Estimated DOV]2 < 32, "0")). Any help anyone can provide would be much appreciated!
Comments
-
When putting quotes around a number, you are converting it to a text string. In your IF statement that is generating the 1, remove the quotes from around it, and that should work for you.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives