Sheet Summary Formula
The above image shows the three highlighted columns I am working with in the Sheet Summary section. If I just calculate the value by subheading, it works well but I need it to identify the status:
=SUMIF(SubHeading:SubHeading, (CONTAINS("Small Works", @cell)), Value:Value)
What I want my formula to do is to sum total the value column if the type of project in the SubHeading column is "service contract", and the Status is either "Projected", "Schedule" or "Not Stated". I am getting #UNPARSEABLE for the below formula:
=SUMIFS(Value:Value, SubHeading:SubHeading, (CONTAINS("Service Contract", @cell), (Status:Status, OR(@cell = "Projected", @cell = "Schedule", @cell = "Not Started")
Can someone help me figure out which part of the above formula is not correct?
Please ignore, I fixed it. I was missing the 2nd bracket after the CONTAINS section:
=SUMIFS(Value:Value, SubHeading:SubHeading, (CONTAINS("Service Contract", @cell)), Status:Status, OR(@cell = "Projected", @cell = "Schedule", @cell = "Not Started"))
Best Answer
-
I'm glad you were able to fix this!
Just a note, you don't actually need the extra parentheses around CONTAINS, if it's causing trouble:
=SUMIFS(Value:Value, SubHeading:SubHeading, CONTAINS("Service Contract", @cell), Status:Status, OR(@cell = "Projected", @cell = "Schedule", @cell = "Not Started"))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
I'm glad you were able to fix this!
Just a note, you don't actually need the extra parentheses around CONTAINS, if it's causing trouble:
=SUMIFS(Value:Value, SubHeading:SubHeading, CONTAINS("Service Contract", @cell), Status:Status, OR(@cell = "Projected", @cell = "Schedule", @cell = "Not Started"))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P. great, thanks for that tip!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!