# How to pull numbers from each cell for a total?

#### mr_ITtoyou

##### New Member
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

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### 6StringJazzer

##### Well-known Member
Have you tried the AVERAGE function?

Excel Formula:
``=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

##### New Member
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

#### 6StringJazzer

##### Well-known Member
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:

Excel Formula:
``=SUM(C2,L2)/SUM(B2,M2)``

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

copy down

Replies
1
Views
67
Replies
1
Views
108
Replies
8
Views
122
Replies
1
Views
227
Replies
5
Views
515

1,186,808
Messages
5,959,928
Members
438,454
Latest member
leopedrini

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back