Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2005
    Location
    Smyrna, Georgia, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Formula (97)

    I am trying to write a formula that will add two cells. I want one cell to stay static and the other to add to the next cell.

    Example: Cell H3 =08/09/05 Cell J2 =7
    Cell J3 =SUM(H3+J2)
    I want to be able to drag the cell that has the this formula in it (Cell J3=SUM(H3+J2) to Cell J4 (and Cell J5, J6 etc) and make it =SUMH4+J2 (and =SUMH5+J2, SUMH6+J2, etc.).
    How would I do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Formula (97)

    You don't need SUM here, just + will do. To make a reference static (absolute in Excel-speak), prefix the column and/or row with $.

    In J3: =H3+$J$2

    If you use the fill handle in the lower right corner of J3 to drag this formula to the cells below, it will become =H4+$J$2, =H5+$J$2, etc.

  3. #3
    Lounger
    Join Date
    Apr 2005
    Location
    Smyrna, Georgia, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Formula (97)

    Thanks. I knew there was a way, just couldn't remember it!

Posting Permissions

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