View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Formula to calulate the weighted average

Dave, just curious about your comment line:
Another formula that may get you into trouble:
=SUMPRODUCT($C$8:$C$11,TRANSPOSE(B17:E17))

Since it works, why would it get the OP into trouble?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
---