I have 5000 rows of employee names with columns for amount paid per week and the pay date. I would like to sum the total amount paid for all employees by calendar month. Column b is the date and column c is amount paid for the week.
Name Date Amount
Bob 1/20/08 200
Chris 1/20/08 400
Bob 1/12/08 210
Chris 1/12/08 125
Thanks,
Danny
Name Date Amount
Bob 1/20/08 200
Chris 1/20/08 400
Bob 1/12/08 210
Chris 1/12/08 125
Thanks,
Danny