Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Month & weekdays
I have a spreadsheet that has 4 columns (month name, date, calls offered, &
calls handled.) I have sorted the file by month, date and now I need to get the averages (by day of week) for each of the last 2 columns. In th sample below there are 2 Wed. and 2 Thurs. that I need to average. I need to place this formula(s) in a different colmn to the right of the data. I'm not sure if a formula will work. I have attempted a pivot table but I am new to these and it gets really ugly everytime I've attempted to create one. There is more data; entire years worth. I am at a loss on how to approach this challenge and any help would be appreciated. I've tried search this site but my search keys aren't working. Thanks for your time and efforts. Sample data: Month DOW Date Offered Handled January Tue 01/01/08 222 209 January Wed 01/02/08 447 412 January Wed 01/02/08 149 521 January Thu 01/03/08 450 398 January Thu 01/03/08 432 405 January Fri 01/04/08 362 328 January Sat 01/05/08 369 321 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr | Excel Worksheet Functions | |||
Weekdays of the month. | Excel Discussion (Misc queries) | |||
averaging a total out over a month | Excel Discussion (Misc queries) | |||
Forumla for averaging within a month | Excel Discussion (Misc queries) | |||
Weekdays | Excel Discussion (Misc queries) |