SUMIFS only if separate cell contains certain text from a different sheet

Hello,

I cannot get this figured out unfortunately. I have a basic knowledge of functions with Excel but it doesn't seem to be transfering over into SmartSheet.

I am trying to SUM dollar amounts based on a few different criterion, but ONLY want the SUM IF a different cell contains a "YES". I am pulling this information from source sheet if that helps.

Here is my current formula in which I get a #UNPARSEABLE error

=SUMIFS({Unfreg trades Range 4}, {Unfreg trades Range 1}, [August 2023]$3, {Unfreg trades Range 2}, [August 2023]$2, {Unfreg trades Range 3}, $[Primary Column]@row), CONTAINS("YES", {Unreg trades Range 1}@cell)

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a try:

=SUMIFS({Unfreg trades Range 4}, {Unfreg trades Range 1}, [August 2023]$3, {Unfreg trades Range 2}, [August 2023]$2, {Unfreg trades Range 3}, $[Primary Column]@row, {Unreg trades Range 1}, CONTAINS("YES", @cell))

All comments

Paul Newcome

Give this a try:

Steve D.

Ahhh, I knew it was something dumb I did. LOL

Thank You @Paul Newcome !!

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.