Calculate the total amount by date
 

HI everybody, I am very new to VBA

I have an excel table, where Column A storing the dates, Column B
storing the names, and column C storing the scores like this:

A B C
12/12/2005 John 30
12/12/2005 Susan 40
12/12/2005 May 80
15/12/2005 John 70
15/12/2005 Susan 20
15/12/2005 Tom 70

I would like to calculate the average score for each date, and storing
the result to another table. How can I do that?

Calculate the total amount by date
 

I suggest that you use a pivot table. Put Date in the row area and AVERAGE
of scores in the data area.
--
Gary's Student


"肥權" wrote:

HI everybody, I am very new to VBA

I have an excel table, where Column A storing the dates, Column B
storing the names, and column C storing the scores like this:

A B C
12/12/2005 John 30
12/12/2005 Susan 40
12/12/2005 May 80
15/12/2005 John 70
15/12/2005 Susan 20
15/12/2005 Tom 70

I would like to calculate the average score for each date, and storing
the result to another table. How can I do that?