G
guilbj2
I'm working on a AHT (average handle time) tracking sheet for a cal
center. When calculating the average time however, I'm having a littl
difficulty. I need to perform this caculation for rows 5-47.
=((B5*D5)+(C5*E5))/SUM(B5:B48)
I need to add the results of ((B5*D5)+(C5*E5))
((B6*D6)+(C6*E6))...... and so on right to ((B47*D47)+(C47*E47)) an
then divide by the sum of b5:b48 to give me an accurate average. Th
average function will not work in this situation due to the varie
number of calls being taken each day (b5) by each agent. If I take th
average of each day's score, days with high volumes of calls ar
weighted equally with days that have lower call volumes and this skew
the numbers considerably.
Is there a way to get the results I need without repeating the sam
section of the formula 47 times with different row references each tim
? It seems to me there must be a more efficient way
center. When calculating the average time however, I'm having a littl
difficulty. I need to perform this caculation for rows 5-47.
=((B5*D5)+(C5*E5))/SUM(B5:B48)
I need to add the results of ((B5*D5)+(C5*E5))
((B6*D6)+(C6*E6))...... and so on right to ((B47*D47)+(C47*E47)) an
then divide by the sum of b5:b48 to give me an accurate average. Th
average function will not work in this situation due to the varie
number of calls being taken each day (b5) by each agent. If I take th
average of each day's score, days with high volumes of calls ar
weighted equally with days that have lower call volumes and this skew
the numbers considerably.
Is there a way to get the results I need without repeating the sam
section of the formula 47 times with different row references each tim
? It seems to me there must be a more efficient way