I have a Excel sheet wherein i have several columns with some numbers. I want
to come out with a statistics based on these values in the columns.

For Ex, the 1st column contains the App name, 2nd contains the response
time, 3rd contains the resolution time, 4th contains criticality etc.

Now i want to come out several outputs like the no. of calls per
application, criticality in each application, time taken to respond /resolve
each call etc.

How can i create a macro for this. Any help is really appreciable.

Many thanks in advance.

Why not just use SUMIF

=SUMIF(A:A,"AppName",B:B)

etc.

--
__________________________________
HTH

Bob

"Govind" <(E-Mail Removed)> wrote in message
newsBB4BDDB-AE3F-470C-A912-(E-Mail Removed)...
>I have a Excel sheet wherein i have several columns with some numbers. I
>want
> to come out with a statistics based on these values in the columns.
>
> For Ex, the 1st column contains the App name, 2nd contains the response
> time, 3rd contains the resolution time, 4th contains criticality etc.
>
> Now i want to come out several outputs like the no. of calls per
> application, criticality in each application, time taken to respond
> /resolve
> each call etc.
>
> How can i create a macro for this. Any help is really appreciable.
>
> Many thanks in advance.
>

for more complicated calculations you could create a function.

in VB edit insert a module
function abc(parameter1, parameter2, parameter3)
' do some stuff
abc = parameter1 * parameter2 + parameter3
end function

in excel cell you would code
=abc(a2,b2,c2)
or whatever cells you want to use

using functions helps when you have long IF statements, they are easier to
read in VB than in a cell


"Bob Phillips" wrote:

> Why not just use SUMIF
>
> =SUMIF(A:A,"AppName",B:B)
>
> etc.
>
> --
> __________________________________
> HTH
>
> Bob
>
> "Govind" <(E-Mail Removed)> wrote in message
> newsBB4BDDB-AE3F-470C-A912-(E-Mail Removed)...
> >I have a Excel sheet wherein i have several columns with some numbers. I
> >want
> > to come out with a statistics based on these values in the columns.
> >
> > For Ex, the 1st column contains the App name, 2nd contains the response
> > time, 3rd contains the resolution time, 4th contains criticality etc.
> >
> > Now i want to come out several outputs like the no. of calls per
> > application, criticality in each application, time taken to respond
> > /resolve
> > each call etc.
> >
> > How can i create a macro for this. Any help is really appreciable.
> >
> > Many thanks in advance.
> >
>
>
>