Adding prices in a column if there are multiple statuses identified

Hi Everyone,

I have no training in formulas and am only self taught. I cannot seem to figure out how to create a code for this situation, thank you in advance for your help!

I would like the formula to add up the dollar values of one column when there are certain statuses selected in a second column, and also is identified as Q1 in a third column. I tried to build the formula and got 'unparseable":

=SUMIFS({Tracker Range 1}, ({Tracker Range 2}, "Approved", OR("Postponed", ({Tracker Range 3}, "Q1"))))

Find more posts tagged with

Formulas

Accepted answers

Heather Duff

Hi Alex,

You're doing great! You're very close. Let me make sure I understand what you want:

Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.

If so, it would look like this:

=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")

Let me know if it works!

Best,

Heather

All comments

Heather Duff

Hi Alex,

You're doing great! You're very close. Let me make sure I understand what you want:

Add the items in Tracker Range 1 that meet the following criteria: Tracker Range 2 equals either Approved or Postponed, AND Tracker Range 3 equals Q1.

If so, it would look like this:

=sumifs({tracker range 1}, {tracker range 2}, OR(@cell="Approved",@cell="Postponed"), {tracker range 3}, "Q1")

Let me know if it works!

Best,

Heather

Alex Madche

OMG Thank you! I am so excited to get a response, this community is great. This is exactly what I was looking for thank you for your help.

Alex

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.