Results 1 to 6 of 6

Search for text, add cell value formula

Threaded View

  1. #1
    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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1