SUMIFS with duplicated column names

[olimajor123]

Hi there,

Please see the attached Sample on dropbox link. I have a Master sheet that I want to track the total of events that occur each week for a sports team.

https://www.dropbox.com/s/mpsxrh3couwu2lh/Sample.xlsx?dl=0

On the Engine sheet this will track the possible events each week and will be ongoing, however I had trouble with a SUMIF as it is looking for column names which are repeated on a few occasions on the Engine tab.

Can you help with a formula that would track the total on the master sheet?

I think the solution to this is relatively simple but when I had a brief look I couldn't get it to work

Thanks in advance

 

[Special-K99]

in Master!B2
=SUMPRODUCT(--(Engine!$A$3:$A$22=$A2)*(Engine!$B$2:$ZZ$2=B$1)*(Engine!$B$3:$ZZ$22))
copy across and down

calculates as far as column ZZ, adjust as required for the future

 

[olimajor123]

in Master!B2
=SUMPRODUCT(--(Engine!$A$3:$A$22=$A2)*(Engine!$B$2:$ZZ$2=B$1)*(Engine!$B$3:$ZZ$22))
copy across and down

calculates as far as column ZZ, adjust as required for the future

That's great. Thanks a lot