Using SUMIFS Formula

Needing help writing a SUMIFS formula! I have tried a few ways, but just get errors.

=SUMIFS({budget}, {Type}, "AMR", {leadership}, "Truttmann"))

I would like to have the sum of the budget if the type is AMR and the leadership is Truttmann. I have multiple types and leaderships that I would be using this for.

Thanks!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Double check your cross sheet references. Make sure they are all single columns by clicking on the appropriate column header.

When doing this, give the sheet a little time to load before selecting the column. Sometimes moving too fast allows you to select a column header before the sheet fully loads in the creator window. Then when the sheet does finally completely load in, the selection automatically reverts to the home cell (top right corner). This happens to me quite a bit when I am in a hurry.

All comments

Paul Newcome

Try removing one of the closing parenthesis from the very end.

jtomeaCH

Of course I didn't see that, thanks. That worked for a second, but now it says #INCORRECT ARGUMENT SET

Paul Newcome

Double check your cross sheet references. Make sure they are all single columns by clicking on the appropriate column header.

jtomeaCH

Thanks again! That worked!

Paul Newcome

Happy to help. 👍️

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.