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?
Help Article Resources
Check out the Formula Handbook template!