C Carol Oct 15, 2009 #1 I have weekly production totals that I need to automatically incorporate into eyar to date totals and can't figure out a formula.
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 Oct 15, 2009 #2 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, 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
