+ Reply to Thread
Results 1 to 2 of 2

Autofill formula changing

  1. #1
    Registered User
    Join Date
    07-16-2010
    Location
    Calgary, AB
    MS-Off Ver
    Excel 2007
    Posts
    1

    Autofill formula changing

    An easy one for all you gurus out there. I have the following formula:

    =sum(a1+b1)

    I want to drag it down and have it pattern like this

    =sum(a2+b1)
    =sum(a3+b1)
    ect.

    However, it goes:

    =sum(a2+b2)
    =sum(a3+b3)

    How do I prevent this. Thanks for answering my dumb question...
    Last edited by ryanegger; 07-16-2010 at 01:16 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Autofill formula changing

    In the first cell, =a1+b$1

    See Help for About cell and range references
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1