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 |
All times are GMT +1. The time now is 01:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com