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!

 

[Pecoflyer]

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join *you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them.* Als
if you do join please post in this thread (link found below) so tha
people who have been following or helping with this query can continu
to do so. :

--
Pecoflye

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html
really IS fast

 

[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!