Weighted Avg - using values from multiple sheets

J

joelmcbride

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top