Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Mar 2008
    Location
    Port Talbot, South Glamorgan, United Kingdom
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No total! (2007)

    The sum of numbers is coming to zero!

    The formula is ok now; shows in the formula area as: =SUM(AA8:AA12) for example

    But the total is still zero!!!

    I've tried changing all the cells from 'General' to 'Number' type in formatting settings to no avail...

    AS

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

    Re: No total! (2007)

    The cells AA8:AA12 are probably still interpreted as text. Try the following:
    - Click in cell AA8.
    - Press F2 to edit the cell, then press Enter.
    - Repeat for AA9 through AA12.
    Do you now get a non-zero sum?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: No total! (2007)

    Alternative to Hans's reply try this:

    Type the number 1 into a clean blank cell (even if its on a blank new sheet)
    Select the number 1 and copy it
    Then select the problematic numbers in AA8:Aa12
    Click the drop down arrow under the paste button on the Home tab and select paste special
    Select the option - Multiply
    Choose OK

    This will multiply the values in the AA column with one and convert it to a number using the General cell format.
    Regards,
    Rudi

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

    Re: No total! (2007)

    Or:
    - Select a blank cell.
    - Copy it to the clipboard.
    - Select the range with "problem" values.
    - Click the dropdown arrow under the Paste button.
    - Select Paste Special.
    - Select the Add option.
    - Click OK.

  5. #5
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: No total! (2007)

    Or try..........

    1] Select cell AA8:AA12

    2] Click "Data" and select "Text to Columns……"

    3] At the Step 1 of 3 press "Finish"

    Check the total, do it get the value?

    Regards

Posting Permissions

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