Formula Issue: Sum of column based on data in two other columns argument error

Hello, I am running into an "incorrect argument" result. I have a sheet and am using data from another sheet to pull information and add it together. I am trying to reference three columns in the first sheet: column

one is total cost, two is fiscal quarter (Q1, Q2, Q3, Q4) and three is last name.

My goal is to total in the cell the amount of

dollars from the first sheet based on which quarter it is and last name (so only adding the total value of the cost if in Q1 for X person with a certain last name).

I am using the following formula and keep receiving incorrect argument and am not to sure where I'm getting this wrong. Should the range with the dollar values have additional information?

=SUMIFS({FY26 External Sponsored Programs Activity Range 1}, "Q1", {FY26 External Sponsored Programs Activity Range 6}, "Ang", {FY26 External Sponsored Programs Activity Range 5}, >1)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

In a SUMIFS, the first {Range} should be the range to add up the values from which is then followed by your range/criteria sets for filtering.

=SUMIFS({Range To Sum}, {1st Criteria Range}, 1st Criteria, {2nd Criteria Range}, 2nd Criteria)

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.