Division For a Range?

[Lautermilch]

My company tracks call time by day and one manager wants an average call time. I have the daily call time in minutes and number of calls per day in rows.

Call time in minutes per day
Bill - 230 300 456 345 456 233

Number of calls made per day
Bill - 34 17 39 56 49 14

I am trying to create a formula that will generate the average call time without have to create it for each column. I've been searching a lot and don't see any way of doing it. All the division by range examples take the data to one cell. I want it for each day. Anyway to do this without creating it for each column?

[shg]

The average call time is =sum(call times)/sum(calls)

[TMS]

Well, the average would be the total minutes divided by the total calls.

So, =SUM(minutes)/SUM(calls)

No idea what the ranges are, but it would be something like:

=SUM(A2:H2)/SUM(A3:H3)

Regards

[Lautermilch]

My company tracks call time by day and one manager wants an average call time. I have the daily call time in minutes and number of calls per day in rows.

Call time in minutes per day
Bill - 230 300 456 345 456 233

Number of calls made per day
Bill - 34 17 39 56 49 14

I am trying to create a formula that will generate the average call time without have to create it for each column. I've been searching a lot and don't see any way of doing it. All the division by range examples take the data to one cell. I want it for each day. Anyway to do this without creating it for each column?

OK, I left out I need the call time average time per day. So if I have a row of thirty days of call times and number of calls, I want to be able to calculate the daily call time average for 30 days. I thought that Excel would have a way to make it easy to repeat the formula without have to do it for each day of the month.

[shg]

Post a workbook and explain in context.