Calculating weekly/year to date totals
I have weekly production totals that I need to automatically incorporate into
eyar to date totals and can't figure out a formula. |
Calculating weekly/year to date totals
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. |
All times are GMT +1. The time now is 06:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com