Use a Pivot Table!
there are loads of on line tutorials for creating pivot tables in excell.
And excell help is good too!

"kiran" wrote:

Hi all,
I have a data as below, each gourp have time with
1st row is Calls Offered
2nd row is Calls Answered
3nd row is Calls Terminated
4rd row is calls Abandoned

i want my out put
A B C D E F G H I J
__________________________________________________ ___________________________________
Group Time Sun Mon Tue Wed Thu Fri Sat Total
__________________________________________________ ___________________________________
APP_OPR 01:00 0 0 0 0 0 0 1 1 1st Row
__________________________________________________ ___________________________________
0 1 1 1 1 0 1 5 2nd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0 3rd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0 4th Row
__________________________________________________ ___________________________________
01:15 0 0 0 0 0 0 1 1 1st Row
__________________________________________________ ___________________________________
0 2 0 3 0 0 0 5 2nd Row
__________________________________________________ ___________________________________
0 0 0 0 0 0 1 1 3rd Row
__________________________________________________ ___________________________________
0 0 4 0 0 0 0 4 4th Row
__________________________________________________ ___________________________________
ATHENA 01:00 1 0 1 0 0 0 0 2
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________
02:10 0 3 1 0 1 0 0 5
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 1
__________________________________________________ ___________________________________
1 0 1 0 0 0 0 2
__________________________________________________ ___________________________________
0 0 0 0 0 0 0 0
__________________________________________________ ___________________________________


I want to know how many call offered, call answered, calls terminated, call
abandoned group wise then by time & then week wise.

TIA