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:

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)

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!!!!