Creating a formula in Macro
 

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.

Creating a formula in Macro
 

Why not just use SUMIF

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

etc.

--
__________________________________
HTH

Bob

"Govind" wrote in message
...
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.

Creating a formula in Macro
 

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" wrote in message
...
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.