I need help discovering a sum formula for a specific criteria in a column
I am trying to figure out a formula where I can find the sum (total cost) of specific criteria in a column. To further explain the breakdown of what I need:
I have a "Total Spend" column and a "Sales Region" column. The Sales Region column includes WC1, WC2, WC3, WC4, GP1, GP2, GP3, GP4, NE1, NE2, NE3, NE4, etc.
I am trying to figure out the "Total Spend" for only "WC1, WC2, WC3, WC4"
Best Answer
-
Hi @Jadyn P
Hope you are fine, please use the following formula:
=SUMIFS([Total Spend]:[Total Spend], [Sales Region]:[Sales Region], OR(@cell = "WC1", @cell = "WC2", @cell = "WC3", @cell = "WC4"))
the following screenshot shows the result.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Hi @Jadyn P
Hope you are fine, please use the following formula:
=SUMIFS([Total Spend]:[Total Spend], [Sales Region]:[Sales Region], OR(@cell = "WC1", @cell = "WC2", @cell = "WC3", @cell = "WC4"))
the following screenshot shows the result.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam. This worked!!! Thank you so much. I was super close and you helped me fill in the gaps I was missing. So appreciated!!
-
You are welcome and I will be happy to help you any time.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!