Small typo

=SUMPRODUCT(($A2:$A1000<=TODAY())*($B$:$B1000))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Roger Govier" wrote in message
...
Hi Ben

With dates in A and Values in B with row 1 containing headers, then
=SUMPRODUCT(($A2:$A!000<=TODAY())*($B$:$B1000))

Change ranges to suit but make them of equal size.
--
Regards

Roger Govier


"Ben Mehling" wrote in message
...
I need to calculate a year-to-date total from a list of daily
production
values. Each day has individual production totals, and it's own daily
total,
and I need to have the daily totals added up into an annual total
elsewhere
on the worksheet. I have asked for help on this before, but then no
longer
needed the spreadsheet and foolishly deleted it without saving the
formula I
was using to do this with. A mistake I won't be making again, believe
me!

Any suggestion as to a direction to go here will be helpful! Thank
you!