Sum(Sumifs or sumproduct(sumifs?

[Bonebeast]

Hi!
I've used the formula =SUMPRODUCT(SUMIFS(E19:E27;A19:A27;{"Team 1";"Team 4";"Team 8"})) to calculate the forecast for specific teams but I want to use the cell reference (A20;A22;A26) instead of the actual team name.
Am I using the wrong formula for that?

 

[Fluff]

You can't, but you could put the team names in another range (say H19:H21) & use this

=SUMPRODUCT(SUMIFS(E19:E27;A19:A27;H19:H21))

 

[Bonebeast]

You can't, but you could put the team names in another range (say H19:H21) & use this

=SUMPRODUCT(SUMIFS(E19:E27;A19:A27;H19:H21))

I see, thank you!

 

[Fluff]

You're welcome & thanks for the feedback.