Calculating weekly/year to date totals

C

Carol

I have weekly production totals that I need to automatically incorporate into
eyar to date totals and can't figure out a formula.
 
B

Bernie Deitrick

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
 
Top