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"

Find more posts tagged with

Accepted answers

Bassam Khalil

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.

All comments

Bassam Khalil

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.

Jadyn P

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!!

Bassam Khalil

@Jadyn P

You are welcome and I will be happy to help you any time.

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.