Sum a column based on a date

[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?

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"karstens" <[email protected]> wrote in
message news:[email protected]...
>
> 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?
>
>
> --
> karstens
> ------------------------------------------------------------------------
> karstens's Profile:
http://www.excelforum.com/member.php...o&userid=17657
> View this thread: http://www.excelforum.com/showthread...hreadid=493626
>

[karstens]

Thank you Bob! That worked. I really appreciate your help!