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

Similar Threads

Finding the weighted average of text that have been given values 1
Weighted Avg - using values from multiple sheets 2
Weighted Averages? 5
Weighted averages 1
Weighted Average Using Row Number 2
Weighted Average with multiple conditions 3
weighted average on a pivot table 2
Round down a weighted average 2

Top