Current Month to date

[Barry]

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

 

[Don Guillett]

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

 

[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?

 

[Don Guillett]

Send me a SMALL worksheet example to MY email, NOT the list.