Try this

=SUMPRODUCT(B2:B7,--(MONTH(A2:A7)=MONTH(NOW())))

if you want to sum a particular month change the MONTH(NOW()) to some other
reference.

If you have multiple years expand to this

=SUMPRODUCT(B2:B7,--(MONTH(A2:A7)=MONTH(NOW())),--(YEAR(A2:A7)=YEAR(NOW())))
--
If this helps, please remember to click yes.


"tleehh" wrote:

A B
2/9/09 100
3/1/09 200
4/4/09 150
4/19/09 125
4/29/09 75
5/4/09 130
I have a spreadsheet with invoice date and amount. I need a formula that
only sums the current month invoice amount.