Results 1 to 5 of 5

Find Cells That Contain Specific Text, Then Add Numbers In Adjacent Column

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2009
    Location
    Rochester, NY, USA
    MS-Off Ver
    Excel 2007
    Posts
    25

    Find Cells That Contain Specific Text, Then Add Numbers In Adjacent Column

    I have data in the following format. Double line break signifies a new column.

    Text String || Number
    c2-ag-1 || 3
    c43-ag-4 || 2
    c55-ag-1 || 5
    c2-ag-3 || 1
    c55-ag-2 || 4

    How would I write a formula that outputs the following.

    If contains:

    c2 || 4
    c43 || 2
    c55 || 9
    Last edited by jessekanclerz; 05-12-2011 at 04:38 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1