Formula to locate and match multiple data and return a result

Hi Folks
Difficult one too explain so have attached a sample sheet which best describes my requirement.

Cheers
hammer

=SUMIFS(Data!$BY$2:$BY$20,Data!$C$2:$C$20,D$1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($A2),Data!$N$1:$BW$1,0)),1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($B2),Data!$N$1:$BW$1,0)),1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($C2),Data!$N$1:$BW$1,0)),1)-COUNTIFS(Data!$C$2:$C$20,D$1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($A2),Data!$N$1:$BW$1,0)),1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($B2),Data!$N$1:$BW$1,0)),1,INDEX(Data!$N$2:$BW$20,,MATCH(TRIM($C2),Data!$N$1:$BW$1,0)),1)

Please Login or Register  to view this content.

Try this and copy across

Hi nflsales
I think we are missing the Data!BX:BX parameter for the first part of the formula-
Cheers
hammer

Okay, I managed to incorporate that (pats self on back )
Many thanks yet again nflsales, much appreciated!