Formula for SUM IFS

RPlaud

I am looking to write a formula that Sums a PO Amount column if PO is a number and Vendor does not equal ABC Company.

Any help would be greatly appreciated!

Paul Newcome

That would look something like

=SUMIFS([PO Amount]:[PO Amount], PO:PO, ISNUMBER(@cell), Vendor:Vendor, @cell <> "ABC")

RPlaud

I could not get this to work, but I am referencing another sheet for both the PO column and Company. I also tried creating a helper column with the following formula =IF(AND(ISNUMBER([PO]@row), [Company]@row <> "ABC Company"), [PO]@row, 0) and then sum the values in the helper column but this isn't working either

Paul Newcome

What exactly did you use, and what exactly do you mean when you say you couldn't get it to work? Was there an error message, or an unexpected number?