meaning of this function
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
|