Writing a formula that Sums the values in the "PO Amount" column for a specific company

RPlaud

I am trying to write a formula that calculates the sum of a column on another Smartsheet ("PO Amount") if the value is a number and is not company "ABC" in the column "Vendor" on another sheet as well. This is the formula I have tried:

=SUMIF(AND({In Vivo Study Tracker Range 1},<> "ABC Company", {In Vivo Study Tracker Range 2, is a number}))

The error message is #INCORRECT ARGUMENT SET

Here is where I am inputting the formula:

And here is the sheet that contains the information I am referencing:

If someone could please help me figure this out it would be greatly appreciated!!!! Thank you in advance for any assistance.

Paul Newcome

You need a SUMIFS to include multiple range / criteria sets.

https://help.smartsheet.com/function/sumifs

.