G
Guest
Hi all
I currently have an excel spreadsheet with 3 columns. Namely, Date, Name and Amount. I would like to sum up the total paid by each person every month. Is there anyway to do this using excel worksheet functions
Please refer to the following sample data for an example of what I am trying to do
Date Name Amoun
12-Jan-04 Tanya 480.5
14-Jan-04 Simon 500.0
24-Jan-04 Tanya 16.2
1-Feb-04 Clement 452.5
10-Feb-04 Tanya 12.5
....
The results I would like to get is as follo
Month Name Total Amoun
January Clement 0.0
January Simon 500.00
January Tanya 496.7
February Clement 452.5
February Simon 0.00
February Tanya 12.5
Thanks
yann
I currently have an excel spreadsheet with 3 columns. Namely, Date, Name and Amount. I would like to sum up the total paid by each person every month. Is there anyway to do this using excel worksheet functions
Please refer to the following sample data for an example of what I am trying to do
Date Name Amoun
12-Jan-04 Tanya 480.5
14-Jan-04 Simon 500.0
24-Jan-04 Tanya 16.2
1-Feb-04 Clement 452.5
10-Feb-04 Tanya 12.5
....
The results I would like to get is as follo
Month Name Total Amoun
January Clement 0.0
January Simon 500.00
January Tanya 496.7
February Clement 452.5
February Simon 0.00
February Tanya 12.5
Thanks
yann