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
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives