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