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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to automate update on weekly reports spreadsheet 0
Display weeks from a Milestone 0
Weekly Report 2
Formula help needed please 2
Formula for calculating target hours against actual hours 12
Expanding Date Formula 0
IF validation for time totaling 2
Auto Sum not working correctly 1

Top