Thread: Offset
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Esrei Esrei is offline
external usenet poster
 
Posts: 21
Default Offset

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