Sum a column based on a date

K

karstens

I have invoice dates in Column A and their dollar amount in column F. I
would like to have another cell say January. And each invoice with a
date in January would be added there to make the Total for all invoices
in January. Is there a formula to do this?
 
B

Bob Phillips

=SUMPRODUCT(--(YEAR(A2:A200)=2005),--(MONTH(A2:A200)=1),F2:F200)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top