SUMIF Partial Text
I'm trying to sum the contract amount if the contract status contains Awarded. Contract Status is a multi-select column so may contain more than one status.
=SUMIF({Contract Status}, CONTAINS(@cell, "Awarded", {Contract Amount}))
This is coming back as $0 when it should be over $57k.
Thoughts?
Best Answer
-
Never mind, I got it!
=SUMIF({Contract Status}, CONTAINS("Awarded", @cell), {Contract Amount})
Answers
-
Never mind, I got it!
=SUMIF({Contract Status}, CONTAINS("Awarded", @cell), {Contract Amount})
-
Great! Glad you found an answer, and thanks for sharing 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Does this not work for contact list cells? I am trying to make it work in a column where there are multiple contacts allowed within a cell.
-
I would suggest using the HAS function in this instance:
=SUMIF({Contact Column}, HAS(@cell, "Contact Name"), {Column to SUM})
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Yes! This worked - thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!