How to pull numbers from each cell for a total?

[mr_ITtoyou]

What I am trying to do is pull the numbers from one cell, (Average Amount Of Calls Per Hour) cell, each month, 12 months and get a total. Then from the total, a formula that will give me an Average Call Per hour, Year to Date.

The cells that I am trying to pull the numbers from to get a total are, G4, Q4, Z4, AI4, AR4, BA4, BJ4, BS4, CB4, CK4, CT4, DC4

Thank you for any help on this.

Average Daily Registration Year To Date

 

[6StringJazzer]

Have you tried the AVERAGE function?

=AVERAGE(G4, Q4, Z4, AI4, AR4, BA4, BJ4, BS4, CB4, CK4, CT4, DC4)

This assumes there are the same number of hours in each month. That probably isn't true, so to get a more precise average we would need to see more of your data. Need the total number of calls and total number of hours for each month.

 

[mr_ITtoyou]

For some reason, the Xl2bb is locking up, so I did a copy and paste. Hope this helps. Thanks

	Total Inbound Calls	Total Calls Handled	Month Total Work Hours	Month Total Hours of Not Ready	Month Total Hours Login to Queue	Averaged Amount Of Calls Per Hour	Total Registrations	Monthly Total Work Days	Average Daily Registrations	Total Inbound Calls	Total Calls Handled	Month Total Work Hours	Month Total Hours of Not Ready	Month Total Hours Login to Queue	Averaged Amount Of Calls Per Hour	Total Registrations	Monthly Total Work Days	Average Daily Registrations	Average Call Per Hour Year To Date	Average Daily Registration Year To Date
Agent 1	399	390	112	51	61	6.393				399	390	112	51	61	6.393
Agent 2	532	522	119	43	76	6.868				532	522	119	43	76	6.868
Agent 3	660	649	119	51	68	9.544				660	649	119	51	68	9.544
Agent 4	571	554	140	87	53	10.453				571	554	140	87	53	10.453

 

[mr_ITtoyou]

6StringJazzer to answer your question the average did not work.​

 

[6StringJazzer]

The list of cells you gave doesn't match the data you pasted.

For the data you pasted, which just shows 2 months, assuming column headers are in row 1 and agent names are in column A:

=SUM(C2,L2)/SUM(B2,M2)

Average total calls handled (not calls offered) per work hour (not hours logged in) .

copy down

 

[mr_ITtoyou]

6StringJazzer, that worked for what I needed. Thanks for your help.​