Summary of 30 worksheets in 1

S

shesha

New Member
Joined
Apr 17, 2006
Messages
4
Report card.xls
BCDEFGHI
2Agent NamesACD CallsAHTTotal AuxStaffed timeAttendance
3Vaibhav KotlapurePresentAbsentLeave
4Roopali Kamat802:4525:09:00493:55:00P  
5Manjunath Gawda  L
6Ralph D'mello723:1341:10:00485:55:00P  
7Shannon Fernandes773:0931:41:00498:02:00P  
8Lakshminarayan K882:1533:55:00488:55:00P  
9Pranav Thakkar703:3964:02:00509:17:00P  
10Dhaval Vyas  L
Apr1



This is a daily data that I have for e.g. April 1st on one worksheet, similarly I have 30 work sheets for 30 days of the month. Now what I want to do is have one summary sheet which would give me a MTD report summing total calls, average AHT, total Aux, Average staffed hrs (all in same format) for the attendance I want a count of all four in this sheet.

I am trying to get all this data in the summary sheet so that I know what is the productivity of each person in a month.

Thanks
Shesh
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
You can sum over several sheets if all the items are in the same cell with a simple formula like this:

=Sum(April1:April30!C4)....this would sum all ADT Calls for Roopali Kamat over the 30 sheets.

you could do the same using average, i.e. =Average(April1:April30!C4)
 
Upvote 0
If you add a sheet at the end of your monthly sheets, you can use:

=SUM('Apr 1:Apr 31'!B3)

To sum B3 from the first sheet to the last.

Hope that helps,

Smitty
 
Upvote 0
Thanks a lot NBVC it works beautifully however I am still stuck with the count function for the Attendance (total days present,days absent, leaves, and totla work off's). I hope you can help me but the cells with attendance have a vlookup formula hope it is not a problem.
 
Upvote 0
Thanks a lot Kris, I got it working the way I want and also I got access to the coolest Add-ins. Thanks a lot to all of you who helped me.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Month to date totals by category
Replies
0
Views
428
chazrab
C
M
  • Solved
Need help with referencing totals from multiple worksheets
Replies
7
Views
337
Fluff
Fluff
Q
  • Locked
  • Question
Loop and Extract data from 2 worksheets with varying rows of data
Replies
3
Views
591
Fluff
Fluff
B
  • Question
Calling macro experts
Replies
4
Views
429
dreid1011
dreid1011
H
  • Question
Losing my mind over this. Is my assignment incorrect or do I just not know what I'm doing? (regarding utility invoices & calendarizing data)
2
Replies
12
Views
1K
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,216,129
Messages
6,129,055
Members
449,484
Latest member
khairianr

Share this page

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
Back
Top