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

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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

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

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

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.