using Pivot Table |
| sundar k replied to Kristian Morphis at 09-May-08 01:48 |
|
Date |
Fees |
| May-08 |
100 |
| Jun-08 |
200 |
| May-08 |
1000 |
| Jan-08 |
100 |
| Jun-08 |
800 |
|
|
|
|
| Sum of Fees |
|
| Date |
Total |
| Jan-08 |
100 |
| May-08 |
1100 |
| Jun-08 |
1000 |
| Grand Total |
2200 |
Lets say you have Date & fees in excel cell in the below format, you can use Pivot Table if you want to group by month & year and show the sum of fees, |
|