SUMIFS Unparseable Error

Hi, I'm attempting to use SUMIFS to sum data (Royalty Rate) from another sheet if the Project Number in the other sheet (Project Num) matches Project Number in the current sheet, and if Based on from the other sheet is "SRP".

Current formula that isn't working is below.

=SUMIFS({Royalty Rate}, {Project Num},[Project Number]@row },{Based On},"SRP")

Appreciate any help on this.

Thanks

Find more posts tagged with

Formulas

SumIfs

Accepted answers

refry

Thank you. I tried this, and it didn't work unfortunately. I then put the old formula back in and got it to work. The issue was I had an extra }.

Correct formula is:

=SUMIFS({Royalty Rate}, {Project Num},[Project Number]@row ,{Based On},"SRP")

All comments

KaitlinH

Maybe try

=SUMIFS({Royalty Rate}, {Project Num} = [Project Number]@row },{Based On} = "SRP"@cell)

refry

Thank you. I tried this, and it didn't work unfortunately. I then put the old formula back in and got it to work. The issue was I had an extra }.

Correct formula is:

=SUMIFS({Royalty Rate}, {Project Num},[Project Number]@row ,{Based On},"SRP")

marc4

FYI, I edit my formulas using Textmate on a mac and then paste them into smartsheet. This lets me see if I have unbalanced parens, braces, etc. I saw a reference that notepad++ on windows will do the same.

There are also tools/sites that will check for balanced punctuation. I find this useful when I have long formulas.

/marc

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.