sum the current month

  • Thread starter Thread starter tleehh
  • Start date Start date
T

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.
 
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())))
 
Thank you. the formula works fine.

Paul C said:
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())))
Click to expand...
 
Back
Top