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)
Best Answer
-
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))
Answers
-
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))
-
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.3K Get Help
- 446 Global Discussions
- 144 Industry Talk
- 478 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 151 Just for fun
- 72 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 302 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!