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?

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.