Monthly Totals From Weekly Row Entries

[Danny99]

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

 

[JimM]

Could you have another column to identify the month

eg in D1

=Month(B1)

you could then pivot on this field or use sumif function

 

[geospatial]

You could use a pivot table and group the dates by month.

 

[Danny99]

Thanks!, and it worked with the extra step. I was trying to combine in one formula.

Danny