SUMIFS with criteria in 2 columns of different sheet

kcaudill1989

I am trying to create a Metrics Sheet referencing three columns of another sheet.

I want to sum the Officials column of the {Officials Reg Numbers} sheet if the Sport column = Sport@row and the Year column = Year@row of the metrics sheet.

=SUMIFS({Officials Reg Numbers - Officials}, {Officials Reg Numbers - Sport}, Sport@row, [{Officials Reg Numbers - Year}, Year@row])

I am getting an #UNPARSEABLE error.
I can get them to work individually as seen in the Metrics sheet image below (Basketball and Cross Country) but not when I put them together.

Can anyone tell me what I am doing wrong?

Officials Reg Numbers sheet:

Metrics Sheet:

Find more posts tagged with

Accepted answers

Darren Mullen

@kcaudill1989 In your formula, =SUMIFS({Officials Reg Numbers - Officials}, {Officials Reg Numbers - Sport}, Sport@row, [{Officials Reg Numbers - Year}, Year@row])

you have "[" and "]" in places they shouldn't be.

Try

=SUMIFS({Officials Reg Numbers - Officials}, {Officials Reg Numbers - Sport}, Sport@row, {Officials Reg Numbers - Year}, Year@row)

All comments

Darren Mullen

@kcaudill1989 In your formula, =SUMIFS({Officials Reg Numbers - Officials}, {Officials Reg Numbers - Sport}, Sport@row, [{Officials Reg Numbers - Year}, Year@row])

you have "[" and "]" in places they shouldn't be.

Try

=SUMIFS({Officials Reg Numbers - Officials}, {Officials Reg Numbers - Sport}, Sport@row, {Officials Reg Numbers - Year}, Year@row)

kcaudill1989

@Darren Mullen Thanks you! That worked. I figured it was something simple that I just wasn't seeing.

Darren Mullen

@kcaudill1989 You're welcome. Yes, it usually is something simple. It happens to all of us!!!!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.