Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Weighted Average
I am new to the weighing of numbers using excel. I really need help. I am able to do this manually, but I it takes too long. Yes I still use the calculator instead of excel. I am new at this. Please help. I need to figure out the Quaterly total of the Average second. Manualy, I divide the total of the month and divide it by quaterly total then this number is the multiple by the months average second. And I repeat for all months. I then add and this is where my 0:18 comes from. Please help if this makes sense. Total Average seconds October 7,727 0:26 November 6,292 0:12 December 5,468 0:14 Quarterly Total 19,487 0:18 -- phm ------------------------------------------------------------------------ phm's Profile: http://www.excelforum.com/member.php...o&userid=31105 View this thread: http://www.excelforum.com/showthread...hreadid=507721 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weighted average in pivot table | Excel Discussion (Misc queries) | |||
Weighted Average - Copy Function | Excel Worksheet Functions | |||
calculating a weighted average using formula | Excel Worksheet Functions | |||
calculating a weighted average uisng formula | Excel Worksheet Functions | |||
Show weighted average value after filter. | Excel Worksheet Functions |