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
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