View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default Weighted Average

"phm" wrote:
first column is the month[,] second is the total of calls
third is the average of minutes per call
October 7,727 - 0:26
November 6,292 - 0:12
December 5,468 - 0:14
Quarterly Total 19,487 - 0:18


I assume the last column is entered in the form mm:ss.
I have trouble making Excel do the right thing with that
format; probably my mistake. But the following should
help you with the concept, if not the solution.

If you are content to enter the third column in seconds,
assuming the table above is in A1:C3, the average is:

=sumproduct(B1:B3,C1:C3) / sum(B1:B3)