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.

Help Article Resources
Categories
Check out the Formula Handbook template!