Current Month to date

B

Barry

I need a formula that will automatically calculate the
totals for the current month and then start over when the
month changes. Thanks!
 
D

Don Guillett

try this where checksA has the dates and checksD has the values to sum
=SUMPRODUCT((MONTH(ChecksA)=MONTH(TODAY()))*ChecksD)
 
B

Barry

I think I might have misled you. The worksheet is updated
on a DAILY basis automatically. The date format looks like
this: 09/02/03.
Your formula returns an error = NUM#. Is that because of
the daily update?
 
Top