View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
afdmello
 
Posts: n/a
Default 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