I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula

I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula.

Example of 2 IF formulas: =IF([Member 2 Registration Type]@row = "Golf & Dinner - General Public", "135") and =IF([Member 2 Registration Type]@row = "Dinner Only", "60")

The IF formulas are working as they should and are populating the cell.

In another cell, I am trying to sum the 135 and 60 that were generated from the IF formula, but I do not believe it is recognizing the "135" and "60" as numerical values.

Is there any ways to fix this?

Find more posts tagged with

Accepted answers

Jhinkle

Thanks! That worked!

All comments

Ro W

I had the same issue, all I had to do was remove the " " quotation marks around the numbers (see below) that way Smartsheet will treat the value as a number instead of a text allowing you to sum the column correctly.

=IF([Member 2 Registration Type]@row = "Golf & Dinner - General Public", 135) and =IF([Member 2 Registration Type]@row = "Dinner Only", 60)

Jhinkle

Thanks! That worked!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.