Does Excel have a weighted average formula

[Heavynbound]

I am trying to find the weighted average of hourly labor costs. I have never tried this in Excel but I know their must be a way. I tried the sumproduct formula but the result is coming out just like the average formula which is not what I want. Example:

[pre]

Hours	      Hrly Cost
360	       109.11
1920	        90.92
1920	        90.92
1427	        71.02
1427	        60.09

[/pre]
Can anyone help me? Thank you

 

[SirJB7]

Hi, Heavynbound!


I edited your topic title to change it to lower case as uppercase is synonymous of shouting at all forums.


No, Excel doesn't have one, and you can build it as, but did you try using the search feature as I wrote at your previous post?


Regards!

 

[Hui]

Heavynbound


You may want to have a read of: http://chandoo.org/wp/2010/06/15/weighted-average-excel/

 

[Guest]

Zou months this case has been to know Zhang Xiaolong what did she arranged outside a nightclub in the Siberian eyeliner,joseph, Zhang Xiaolong a hands her know