Weighted Avg - using values from multiple sheets
I maintain a spreadsheet for a telephone hotline. We track total
number of calls received (column F) as well as average time to answer the call (column J). To analyze the month's average time to answer, I use the following weighted average formula: SUMPRODUCT (J5:J26,F5:F26)/SUM(F5:26). I have 2 questions relating to this: 1) Is the above formula correct to determine the average speed to answer? I've assumed the weights to be the total number of calls received. 2) I have a different spreadsheet for each month (Jan, Feb, etc.). How can I properly show the weighted average as a Year-To-Date number? Thanks for your consideration, Joel McBride Reno, Nevada |
All times are GMT +1. The time now is 02:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com