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.