Formula - Adding a Column

Today, I created the following formula in a cell
=IF(AND([Roommate in Room?]@row = "Yes", [Requested Bed Type]@row = "Double"), ".5", IF(AND([Roommate in Room?]@row = "No", [Requested Bed Type]@row = "Double"), 1, 0))
As you can see one of the variables returns a .5. The formula works great until I go to my sheet summary and want to add up that column
=SUM([# of DD Rooms Needed]:[# of DD Rooms Needed]) It returns the answer of 1 when it should be 3.5. Why won't it add up this column for me?
Best Answer
-
Try removing the quotes from around the .5 in your formula. The quotes make the formula output a text value which cannot be added.
Answers
-
Try removing the quotes from around the .5 in your formula. The quotes make the formula output a text value which cannot be added.
-
Thank you, that worked. 😊 I kept looking at the formula and I just couldn't see that that was the issue.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!