Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Good day
This is my formula to add year to date totals in a budget. I compiled this with the help of the discussion group =+SUM(OFFSET('IS Bud 2007'!$D$13:$O$13,0,0,1,(MONTH('Income Statement'!$D$1)-8))) My problem is that my fin year is form Sep-06 to Aug-07 so this worked perfectly until Dec-06 but nou Jan-07 gives Ref# error Could you please also explain the formula. Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Offset Help | Excel Worksheet Functions | |||
OFFSET PLEASE HELP! | Excel Discussion (Misc queries) | |||
=offset ??? | Excel Worksheet Functions | |||
Offset | Excel Worksheet Functions | |||
offset | Excel Worksheet Functions |