Formula - Adding a Column

Lori Leighton

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?

Paul Newcome

Try removing the quotes from around the .5 in your formula. The quotes make the formula output a text value which cannot be added.

Paul Newcome

Try removing the quotes from around the .5 in your formula. The quotes make the formula output a text value which cannot be added.

Lori Leighton

Thank you, that worked. 😊 I kept looking at the formula and I just couldn't see that that was the issue.

Paul Newcome

Happy to help. 👍️