Urgent help...

[kiran]

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

 

[Atishoo]

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

 

[Ms-Exl-Learner]

The data you have shown below is not organised or planned perfectly to
retrieve the desired results easily. So for your present data structure I
can suggest you that in the end of the B column you have to manually put sum
function and select each 1st Row cell in B column. Like this you have to do
it for 2nd Row Cells, 3 Row Cells & Fourth Row cells.

But my suggestion is to change your data structure first, I have give below
the format, if you make the data capturing system like this then you can take
all the reports whichever you require in a a minute time with the use of
pivot table.

A B C D E F G H I J K
Group Status Time Mon Tue Wed Thu Fri Sat Sun Mon
APPOPR Calls Offered
APPOPR Calls Offered
APPOPR calls Abandoned
APPOPR calls Abandoned
APPOPR Calls Offered
APPOPR calls Abandoned
APPOPR calls Abandoned
APPOPR Calls Offered
Have a Look in some pivot table examples in web or help menu.

If this post helps, Click Yes!