Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Autosum ignoring empty cells (97 SR-2)

    Is there a way to add all the cells in a column using autosum when some of the cells have no values in them?

    clark

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autosum ignoring empty cells (97 SR-2)

    What do you want to add to the sum for an empty cell?
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autosum ignoring empty cells (97 SR-2)

    If you mean how to expand the selected cels you get when you press the Autosum button, simply hold the shift key and press arrow-up until you've reached the range you want.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Posts
    165
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autosum ignoring empty cells (97 SR-2)

    The empty cell has the value of 0, but unless I put in 0, Excel ignores the cell. So, if I have a column of 10 cells, the first six (A1 through A6) have values, the seventh (A7) is empty, and A8, A9, and A10 have values, if I want to add the column by putting an autosum formula in A11, Excel only gives me the sum of cells A8 through A10, whereas I want the sum of all cells (A1 through A10).
    Clark

  5. #5
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Autosum ignoring empty cells (97 SR-2)

    After you press the AutoSum button, you can change the selected cells to whatever you want. As an alternative, you can pre-select the cells for the sum along with an empty cell at the bottom and press the AutoSum button.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  6. #6
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Autosum ignoring empty cells (97 SR-2)

    Highlight the block of cells you wish to sum and click on the Autosum icon. this will then add an sum() to the end of your block.


    Peter

Posting Permissions

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