SumIfs Exclude Column from Other Sheet

Hello,

I've recently learned due to our finance system, we are duplicating spend amounts, so I now need to eliminate all items listed as closed in the sheet where the names and totals live.

I have searched and tried multiple formulas, but I must be missing something small. I have an existing formula, which finds all vendors with a single name and sums the total amount committed to them.

I have used a not, and excluder, and on. My original formula is =SUMIFS({Total}, {Vendor}, 2 = Vendor3)

Two of My Last Attempts are Below

=SUMIFS(({Total}, {Vendor}, 2 = Vendor2), AND({PO Status}, @row <>"Closed"))

=SUMIFS(({Total}, {Vendor}, 2 = Vendor2), {PO Status}, @cell <>"Closed")

This is a screenshot of where the formula lives

And a screen shot of the other sheet where the data lives

What am I missing?

Find more posts tagged with

Accepted answers

Paul Newcome

Your second one is the closest. Just remove the closing parenthesis from after "Vendor2".

All comments

Paul Newcome

Your second one is the closest. Just remove the closing parenthesis from after "Vendor2".

TracyS

Thanks so much, I knew it was something small

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.