+ Reply to Thread
Results 1 to 5 of 5

Calculate the numerical portion of entries in a range of cells & show sum in another cell

  1. 06-08-2019, 10:59 PM #1
    gdgt808
    gdgt808 is offline
    Registered User
    Join Date
    06-07-2019
    Location
    Hawaii
    MS-Off Ver
    2013
    Posts
    4

    Calculate the numerical portion of entries in a range of cells & show sum in another cell

    My original question was answered by TMS, but I have a follow-up question and was advised to start a new thread.

    Original thread: 1278713-count-text-in-a-range-and-for-each-instance-add-a-value-to-another-cell

    My question now is:

    To expand on the same idea, is there a way to put a range in? Say for instance that the text in the row is between "LA1" and "LA10", the number after LA gets added to the other cell.

    For instance: E10 contains LA3, G10 contains LA9, M10 contains LA5. Then cell T10 would add all the numerical portions for a total of 17.

    Any ideas or suggestions?

    Thanks again for the help!
    Reply With QuoteRegister To Reply
  2. 06-08-2019, 11:37 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Calculate the numerical portion of entries in a range of cells & show sum in another c

    My range was V6:V8, but see if you adapt this to your needs?
    =SUMPRODUCT(--MID(V6:V8,3,9))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-09-2019, 03:57 PM #3
    gdgt808
    gdgt808 is offline
    Registered User
    Join Date
    06-07-2019
    Location
    Hawaii
    MS-Off Ver
    2013
    Posts
    4

    Re: Calculate the numerical portion of entries in a range of cells & show sum in another c

    Thank you. This kind of works, but i have to enter LA in all cells otherwise it doesn't work. I'll keep working on it.

    Thanks again for your help!
    Reply With QuoteRegister To Reply
  4. 06-09-2019, 10:51 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,050

    Re: Calculate the numerical portion of entries in a range of cells & show sum in another c

    ummm that's what you said you had??

    Please Login or Register  to view this content.
    Are you now saying you may have cells withOUT LA in them?

    I suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    Reply With QuoteRegister To Reply
  5. 06-10-2019, 12:46 AM #5
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Calculate the numerical portion of entries in a range of cells & show sum in another c

    Try this ARRAY formula, to be confirmed with Ctrl+Shift+Enter keys together.

    =SUM(IFERROR(0+(SUBSTITUTE(E2:O2,"LA","")),0))
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    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. Help with functions to make cells calculate data or show blank cell based on other cells
    By IndyRyan1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2017, 03:24 PM
  2. [SOLVED] List cell entries based on numerical criteria
    By jcswaby in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-17-2016, 04:06 AM
  3. Show blank cell, until entries in another row of cells
    By Roger1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-04-2015, 02:41 PM
  4. Formula that assigns numerical values to specific text cell entries and provides a total
    By excelnewbie4444 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2013, 09:35 AM
  5. Can I format a numerical cell to show as textual?
    By skiwoods in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2013, 10:32 PM
  6. cut a portion of a cell's contents and paste the cut portion into the net column
    By NJEvan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2010, 05:08 AM
  7. COUNTIF function if numerical entries in range
    By Si902 in forum Excel General
    Replies: 7
    Last Post: 06-25-2010, 10:11 AM

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