Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum year to date totals for particular month | Excel Worksheet Functions | |||
Year to date totals | Excel Discussion (Misc queries) | |||
Template to track weekly & monthly totals, by day & date? | Excel Discussion (Misc queries) | |||
Calculating monthly totals for current and previous year | New Users to Excel |