Current Month to date

  • Thread starter Thread starter Barry
  • Start date Start 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!
 
try this where checksA has the dates and checksD has the values to sum
=SUMPRODUCT((MONTH(ChecksA)=MONTH(TODAY()))*ChecksD)
 
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?
 
Back
Top