Help - SUMIFS issue Excel vs Smartsheet

I have this basic SUMIFS in Excel but cannot seem to replicate it within Smartsheet?

=SUMIFS($F$10:$F$12,$G$10:$G$12,D3)*E3/100

Range F10:F12 are figures related to commission, Range G10:G12 are names of items that are already listed in a different column (D). Column E is an amount already in the sheet

I'm looking for this formula to automatically do a sum based on 2 results manually entered in other cells.

The formula seems different in Smartsheet and is asking for a Criterion1 which I don't seem to need in Excel?

Any help appreciated.

Lincoln

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Criteria 1 is where you have "D3" in your excel version.

Your Smartsheet version is going to look almost identical except you will need to use your actual column names.

Lincoln Brown

Thank you Paul.

I have tried this but hasn't worked. There are gaps in the names of the columns. Does that matter? ie Mortgage Lender is Column D so I have it as ,Mortgage Lender3)

Paul Newcome

When there is a space, special character, or number within a column name in Smartsheet, the column name needs to be wrapped in square brackets.

[Mortgage Lender]3

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.