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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!