sum the current month
Thank you. the formula works fine.
"Paul C" wrote:
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.
|