Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
MG
MG asked in Computers & InternetSoftware · 8 years ago

Adding continuous cells in Excel?

I need the sum of A1 and B1, then A1 through C1, then A1 through D1, etc, etc. And want these values to appear in B2, C2, D2, etc, etc.

2 Answers

Relevance
  • expletive_xom
    Lv 7
    8 years ago
    Favorite Answer

    sure,

    hope you know how to Copy&Paste

    use the obvious SUM() function....but remember to make A1 "absolute" by using $

    copy&paste this in B2

    =SUM($A$1:B1)

    you should get the A1+B1 result

    - B2

    - select a bunch of cell to the right of B2

    - click paste

    done

    the $ means that the cell is anchored and will not change....but the 2nd cell will be changing.

    let me know how it works.

  • Anonymous
    8 years ago

    B2: sum($A$1:B1)

    C2-D2-etc,etc: Copy/Paste the above formula

    Source(s): http://www.facebook.com/AuthorRickGrantham
Still have questions? Get your answers by asking now.