SumIfs Exclude Column from Other Sheet

TracyS

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?

Paul Newcome

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

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. 👍️