+ Reply to Thread
Results 1 to 3 of 3

SUMIF Function but with text results and variables

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2013
    Posts
    67

    SUMIF Function but with text results and variables

    Hello

    I am looking for a function similiar to a SUMIF function that will work with text and not numbers. For example:

    Row 1 = Name of Different Fruits
    Row 2 = Color of each fruit

    In row 3, Column A, I want to be able to type the name of the fruit, and in Column B, I want the color of that fruit to be displayed.

    The function should search the range for the name of the fruit, and then answer with the corresponding cell below the fruit name.

    Thanks!

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: SUMIF Function but with text results and variables

    Perjaps something like this?

    =index(b2:iv2,match(a3,b1:iv1,0))
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    08-29-2013
    Location
    new york, new york
    MS-Off Ver
    Excel 2013
    Posts
    67

    Re: SUMIF Function but with text results and variables

    Ultimately I need it to refer to other worksheets. Does index work with closed worksheets?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. IF function: Using text in logical_test with multiple variables and replacing with text
    By SarahRachelJones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2012, 02:17 PM
  2. [SOLVED] Sumif like function for text
    By Kalts in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-18-2012, 09:50 AM
  3. [SOLVED] IF Function for Text and Multible Results in One Cell.
    By Bjourne in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-26-2012, 05:22 AM
  4. Converting MID function results into Text?
    By SiemensIC in forum Excel General
    Replies: 5
    Last Post: 10-14-2010, 09:38 AM
  5. Cells display function's text rather than its results
    By tonerowlabs in forum Excel General
    Replies: 4
    Last Post: 07-08-2006, 07:55 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