| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate the amount of time over a permitted amount (12 hours) | Excel Discussion (Misc queries) | |||
| calculate year-to-date total | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| calculate price * quantity = total amount in a row of excel forml. | Excel Worksheet Functions | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
Hybrid Mode
