+ Reply to Thread
Results 1 to 12 of 12

separate the last digit from 0-9 and then add the quantities of each digit

  1. 08-01-2020, 10:30 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    separate the last digit from 0-9 and then add the quantities of each digit

    separate the last digit from 0-9 and then
    add the quantities of each digit
    https://www.excelforum.com/attachmen...1&d=1596292189
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-01-2020, 10:56 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    How about
    =SUMPRODUCT(--(RIGHT($A6:$O6,1)+0=Q$5))
    Reply With QuoteRegister To Reply
  3. 08-01-2020, 05:09 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    hello fluff12 error==SUMPRODUCT(--(RIGHT($A6:W3)+0=Q$5))
    Reply With QuoteRegister To Reply
  4. 08-01-2020, 05:12 PM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    Why have you change $A6:$O6 to $A6:W3?
    If the formula is in Q6 you will get a circular reference.
    Reply With QuoteRegister To Reply
  5. 08-01-2020, 05:21 PM #5
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    hello hello, I haven't changed, it turns out that my excel is in Portuguese, in excel an error message appears
    Reply With QuoteRegister To Reply
  6. 08-01-2020, 05:23 PM #6
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    The formula you posted in post#3 saying it was giving an error, is not the formula I posted.

    Why not try the one I supplied?
    Reply With QuoteRegister To Reply
  7. 08-01-2020, 05:32 PM #7
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    Here it is in the sheet
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 08-01-2020, 05:39 PM #8
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    ok but I try to click on Q6 and drag to do in the other drawings and the formula crashes
    Reply With QuoteRegister To Reply
  9. 08-02-2020, 06:21 AM #9
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    Really jorel...

    I have said this multiple times before...Seems you never want to learn...Always just want answers...you never try yourself...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  10. 08-02-2020, 08:06 AM #10
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    I candrag that formula down & across for all the data in your sample without any problem.
    Reply With QuoteRegister To Reply
  11. 08-02-2020, 08:09 AM #11
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    ok, fluff13 , sintek, corret, conglatulations , thank you!!!
    Reply With QuoteRegister To Reply
  12. 08-02-2020, 08:45 AM #12
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: separate the last digit from 0-9 and then add the quantities of each digit

    Glad we could help & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Extract 1, 2 or 3-digit Numbers from Text String but Ignore 4-Digit Dates
    By S_Rycroft in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2020, 12:03 PM
  2. [SOLVED] separate numbers with the initial zero digit from 01 to 09 then add up the quantities
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2019, 03:55 PM
  3. [SOLVED] separate the last digit from each draw line and add up to each * digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-17-2019, 05:28 PM
  4. Mexcel-2010, 16 digit number's last digit changes to zero, format cell doesn't help
    By pansee517 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-03-2019, 06:05 AM
  5. Bank Recon - How to convert 8 digit formatted check numbers to 6 digit
    By Quisp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:55 PM
  6. [SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2014, 12:57 AM
  7. Entering 5 digit number, where each digit creates a specific result based on a list.
    By big_worm81 in forum Excel General
    Replies: 2
    Last Post: 06-17-2010, 08:36 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1