sum the current month

[tleehh]

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.

 

[Paul C]

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())))

 

[tleehh]

Thank you. the formula works fine.

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())))