How to count the frequency of data and also tally value from an array of Excel record

[KIM SOLIS]

Hi all,


I have this Excel data shown in three columns. per Table1, below:


Name................ Grade Level................... Fees
Leo ..................... Gr-5 ......................1,200.00
May .....................Gr-6 ......................5,000.00
Jed ......................Gr-5 ........................800.00
Ana .....................Gr-5 ........................100.00
Wil ......................Gr-4 ........................300.00


...and so on (I have about 800 rows of similar data to tally)


What I want to do is to generate an Excel Report, per Table2 below, that counts the frequency in the Grade Level column and adds up Fees by Grade Level, as in:


Total Students........... Grade Level ............Total Fees
1 .............................Gr-4 .....................300.00
1 ............................ Gr-6 ...................5,000.00
3............................. Gr-5 ...................2,100.00


The output i need is that the collated data should display in only one row as displayed above. Both reports must be in one worksheet, with Table1 in sheet1 and Table2 in sheet2. As much as possible my Table 2 output should automatically display (after setting some excel formula as needed).



Is there a way to do this simply and quickly in Excel. Thanks for any advice.

Kim S.