Column A has the date mm/dd/yyyy
Column B has the clients name
Coulmn C has the amount paid
Column D is January's total paid and E = Feb, F = March, etc.
I want in the month total columns (D - O) to display the total amount in
column C for each respective month.
So in D1 I want a formula that will look at the date (columnA) and add all
the rows that have January (01/01/2007) as the date added up and entered in
D1. I would copy the formula for each month.
Is there a way to do this? And if so, what is the syntax?
Thanks,