Sum Across As Formula Dragged Down

    Hi,
    From the title "Filling Down Formula From Source That Goes Horisontally" I hope that someone understands what I mean. If I try to autofill a formula where the source cells that I want to autofill is organised in an horisontal fashion instead of vertical fashion, then the autofill always goes in an vertical fashion. Is there a way to get around this, macro, formula??


    Thanx


    Robert

    .¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.·´¯'·.¸¸·´¯'·.¸¸.· ><((((º>

    Re: Filling Down Formula From Source That Goes Horisontally


    As an illustration, if you've got numbers going horizontally from B1, this formula in A1 will sum across as you drag down:


    =SUM(OFFSET($B$1,0,0,1,ROW()))

    Re: Filling Down Formula From Source That Goes Horisontally


    Ok I must be a dunce cause I cannot get this to work.
    I have enclosed an example of the data that I need to autofill via the offset in the sheet extraction. The sheet Extraction offset is where the data in extraction should be offset into.


    all the best


    Robert

    Re: Filling Down Formula From Source That Goes Horisontally


    Try this...


    Quote

    Note If the fill handle is not displayed, click Options on the Tools menu. On the Edit tab, select the Allow cell drag and drop check box. - Mircrosoft


    Click and drag the bottom right corner of a cell or group of cells and drag them to the preferred location.


    ah, just realized what you are saying... Could you repost a sample of the problem? I only see a string of dates on your current sample.


    regards,


    -Dude

    Re: Filling Down Formula From Source That Goes Horisontally


    Dude - it's hgus393 who's asking, I was just trying to answer.


    Robert - mine was just an illustration as you didn't specify what you wanted.

    Re: Filling Down Formula From Source That Goes Horisontally


    Sorry about that StephenR


    I was multi tasking and read the post wrong.


    -Dude

    Re: Filling Down Formula From Source That Goes Horisontally


    Good point, girls can be dudes too. Besides a "Dude" is more of a state of being than a name.:rock:

    Re: Sum Across As Formula Dragged Down


    Quote

    Who said men can't multi-task?

    My Wife and I can't think of a valid argument in my case :)


    THREAD SPLIT OFF TO http://www.ozgrid.com/forum/showthread.php?t=87490

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login