Why is my sumproduct with indirect forumla only returning the first result? Google Sheets

[korfballchick]

Hi,
I have multiple tabs which contain stats from different sports matches.
I want to create a summary sheet which sums data from the various columns based on the name of the athlete.

I have used this formula:
=ArrayFormula(SUMPRODUCT(SUMIF(INDIRECT("'"&WalesMatches&"'!A7:A25"),A14,INDIRECT("'"&WalesMatches&"'!L7:L25"))))

In which "WalesMatches" is a named range for the separate tabs.
A7:A25 is where the name of the athlete is entered on the various tabs
L7:L25 is the total of shots scored on the various tabs

Can anyone explain why this isn't returning the sum of all tab? I'm only getting the first tab's total (i.e. if I change the tabs contained in the named range, I still only get the total from the first tab to pull through, not the sum of all tabs).

 

[korfballchick]

OK, thank you, will do @Fluff.

Will my formula not work in googlesheets then? Is there something else similar I can try?

 

[Fluff]

I know nothing about Google Sheets, so cannot help.

 

[cfuret]

did you solve this issue ? I have the same. How to make this work on Google ?