Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number Adding (Office 97)

    <img src=/S/confused3.gif border=0 alt=confused3 width=45 height=45>
    OK, I have whole numbers that are broke up into individual cells for each digit. I want to be able to add these numbers. With them being broke up into single cells I have no idea how to add them up. I hope I am making sence. Any help or ideas will be greatly appriciated.
    <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

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

    Re: Number Adding (Office 97)

    The idea is to assemble the numbers from the digits, add them, then break up the result into individual digits again. You could use VBA code, but I have attached a workbook using formulas. Column F is hidden; it contains the intermediate results.

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

    Re: Number Adding (Office 97)

    There are a number of possibilities that could cause problems here (like are the numbers really numbers or are the text values), and I also am not 100% clear on what you want to do. Could you upload an example workbook that shows what you are trying to do?
    Legare Coleman

  4. #4
    Star Lounger
    Join Date
    May 2004
    Location
    Asheville, North Carolina, USA
    Posts
    65
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Adding (Office 97)

    Thanks Hans, that what I was looking for but I sure was hoping for something simpler. But I am not going to complain.
    Coleman, Hans attachment shows what I am talking about.
    Thanks for all the help.
    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Number Adding (Office 97)

    A simpler way to calculate could involve SUMPRODUCT.

    Insert a new row1 and put in 10000 in A1, 1000 in B1, 100 in C1, 10 in D1 and 1 in E1
    Then in row 2 and 3 A:E have what you currently have in row 1 &2
    In F2 enter the formula:
    =SUMPRODUCT($A$1:$E$1,A2:E2)

    and this can be copied to the next row (or even more rows if you want to sum more than 2 rows together)

    In the last row (3 in your spreadsheet and 4 with row 1 inserted, you can put in A4 the formula:
    =MOD(TRUNC($F$4/A1),10)
    and copy this from A4 to B4:E4

    Steve

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

    Re: Number Adding (Office 97)

    Yes, that's simpler. <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

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

    Re: Number Adding (Office 97)

    Is this simpler than Hans' solution. There are no hidden calculations.
    Legare Coleman

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

    Re: Number Adding (Office 97)

    That works well. One note: you must have installed the Analysis Toolpak add-in (Tools | Add-Ins...), for the QUOTIENT function belongs to this add-in.

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

    Re: Number Adding (Office 97)

    Thanks, I missed that. This should work just as well, and does not require the addin.
    Legare Coleman

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Number Adding (Office 97)

    Hi,
    Just for completeness, here's another approach! The attached shows it with an intermediate column and without.
    FWIW.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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