Results 1 to 4 of 4

Addind values if text is contained in cells

Threaded View

  1. #1
    Registered User
    Join Date
    08-04-2011
    Location
    Bordeaux, France
    MS-Off Ver
    Excel 2007
    Posts
    5

    Addind values if text is contained in cells

    Hey guys,

    So here's the deal :

    In my first tab, I have some raw data that is presented as such :

    Column A contains text
    Column B contains numbers

    So that gives us something like :

    text1 8
    text2 19
    text3 7

    etc.

    Now here's what I want to do :
    In the cell C1 I will enter a text value.
    I'd like to have a formula that is gonna check the entire A column for cells that CONTAIN (not strickly equal) the text value I put in C1. Everytime the C1 value is present in a cell in the column A, the number in the column B is added to the sum.

    For example, if I put "potato" in C1, and my A and B columns are as follow :

    potato chip 8
    potato 9
    salad 8
    food 3
    potatos 1

    The formula should give me the result 8+9+1 = 18

    Any idea how to get there ?

    Thanks,
    Last edited by Ranu; 02-03-2012 at 11:23 AM. Reason: Solved

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