E
El Bee
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
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