Carol,

Array enter - enter using Strl-Shift-Enter - formula like

=SUM(IF(YEAR(A2:A2000)=YEAR(NOW()),B2:B2000))

where you have dates in column A and values to total in column B.

HTH,
Bernie
MS Excel MVP


"Carol" wrote in message
...
I have weekly production totals that I need to automatically incorporate into
eyar to date totals and can't figure out a formula.