How to pull numbers from each cell for a total?

mr_ITtoyou

New Member
Joined
Mar 26, 2021
Messages
31
Office Version
  1. 2016
Platform
  1. Windows
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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

6StringJazzer

Well-known Member
Joined
Jan 27, 2010
Messages
1,121
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
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
Joined
Mar 26, 2021
Messages
31
Office Version
  1. 2016
Platform
  1. Windows
For some reason, the Xl2bb is locking up, so I did a copy and paste. Hope this helps. Thanks

Total Inbound CallsTotal Calls HandledMonth Total Work HoursMonth Total Hours of Not ReadyMonth Total Hours Login to QueueAveraged Amount Of Calls Per HourTotal RegistrationsMonthly Total Work DaysAverage Daily RegistrationsTotal Inbound CallsTotal Calls HandledMonth Total Work HoursMonth Total Hours of Not ReadyMonth Total Hours Login to QueueAveraged Amount Of Calls Per HourTotal RegistrationsMonthly Total Work DaysAverage Daily RegistrationsAverage Call Per Hour Year To DateAverage Daily Registration Year To Date
Agent 139939011251616.39339939011251616.393
Agent 253252211943766.86853252211943766.868
Agent 366064911951689.54466064911951689.544
Agent 4571554140875310.453571554140875310.453
 

6StringJazzer

Well-known Member
Joined
Jan 27, 2010
Messages
1,121
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
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
 
Solution
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,491
Messages
5,764,676
Members
425,229
Latest member
Rashid mahmood

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top