+ Reply to Thread
Results 1 to 6 of 6

Search for text, add cell value formula

  1. 11-03-2015, 03:39 PM #1
    TWP
    TWP is offline
    Registered User
    Join Date
    08-24-2015
    Location
    Ontario
    MS-Off Ver
    Windows7
    Posts
    23

    Search for text, add cell value formula

    Hi Forum,
    I posted this already but I've changed the attachment to better help explain what I'm seeking.

    I'm looking to get a formula that will search the first sheet for specific text, once it finds the text, I'd like it to take the value next to it and continuously keep adding the tally on the summary page.

    any help would be GREATLY appreciated!
    Attached Files Attached Files
    Last edited by TWP; 11-03-2015 at 04:06 PM. Reason: SOLVED
    Reply With QuoteRegister To Reply
  2. 11-03-2015, 03:45 PM #2
    Pete_UK
    Pete_UK is online now
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,733

    Re: Search for text, add cell value formula

    Use this formula in C3 of the Summary sheet:

    =SUMIF(Sheet1!$A$2:$A$28,A3,Sheet1!$C$2:$C$28)

    then copy down.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 11-03-2015, 03:46 PM #3
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Search for text, add cell value formula

    In C3 and copy down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Last edited by AlKey; 11-03-2015 at 03:48 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  4. 11-03-2015, 03:51 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Search for text, add cell value formula

    I'm guessing what you are really looking for is SUMIF, or, if there are several conditions, SUMIFS.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  5. 11-03-2015, 04:05 PM #5
    TWP
    TWP is offline
    Registered User
    Join Date
    08-24-2015
    Location
    Ontario
    MS-Off Ver
    Windows7
    Posts
    23

    Re: Search for text, add cell value formula

    OMG the SUMIF worked!!!!
    I could kiss you !!!!

    Yeah!!
    Thank you thank you!!!!!!!
    Reply With QuoteRegister To Reply
  6. 11-03-2015, 04:07 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: Search for text, add cell value formula

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    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. Search and Replace Text with a formula and adjacent cell with a formula
    By 1p3261 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2015, 12:14 PM
  2. Formula/macro to search cell text and assign value?
    By shibbyshibby in forum Excel General
    Replies: 1
    Last Post: 02-03-2014, 10:53 AM
  3. formula to search for text and display all in single cell
    By gorelordz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-28-2014, 12:12 AM
  4. IF(count(search) Function not working when search from text from a cell
    By joshnathan in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-09-2013, 05:13 AM
  5. [SOLVED] Formula to display cell if the text content partially matches a search term
    By Avestron in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2013, 04:07 AM
  6. [SOLVED] Formula to search array for text and return value from an offset cell
    By tif4300 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2012, 09:04 PM
  7. [SOLVED] how to use a wildcard with an IF formula to search for text in a cell
    By nje in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-23-2012, 07:40 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