AFD,

Overall, that formula yields the same as this long mess:

D2*MAX(B2:B14)/B2 + D3*MAX(B2:B14)/B3 +...+ D14*MAX(B2:B14)/B14

HTH,
Bernie
MS Excel MVP



"afdmello" wrote in message
...
MAX($B$2:$B$14)/$B$2:$B$14
I understand it as : find out the maximum value of the numbers in column B
row 2 to 14 and divided by ???


The whole formula as displayed in the formula bar is :

=SUMPRODUCT(D2:D14,MAX($B$2:$B$14)/$B$2:$B$14)


AFD