Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
I am trying to set up a table that, when you change the date every month for a range of values by month it sums up the YTD value. eg Jan Feb Mar April May June Salaries 10000 12000 18000 18000 20000 20000 Annual Leave 6000 5000 5000 4500 5500 6000 for example , If we are in the month of April, if I enter the date April the formula should calculate Jan - April Salaries and annual leave? And if I change the date to June the formula should calculate value from Jan to June. Hope it makes sense Thanks -- SC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating different values | Excel Discussion (Misc queries) | |||
CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES | Excel Worksheet Functions | |||
calculating matrix values | Excel Worksheet Functions | |||
How do I average a formula without calculating zero values? | Excel Discussion (Misc queries) | |||
Pbl calculating US$ values | Excel Discussion (Misc queries) |