Hi,
Required a help to correct the formula which is work in first cell perfectly and given a seeking results then for getting further results when I can drag to below cell it returns #REF!.
=SUMPRODUCT($B$7:$B$23,INDEX($C$7:$F$23,,MATCH(H6,$C$4:$F$4,0),MATCH(I6,$C$5:$F$5,0)))
Thanks for the help,
Required a help to correct the formula which is work in first cell perfectly and given a seeking results then for getting further results when I can drag to below cell it returns #REF!.
=SUMPRODUCT($B$7:$B$23,INDEX($C$7:$F$23,,MATCH(H6,$C$4:$F$4,0),MATCH(I6,$C$5:$F$5,0)))
Thanks for the help,