+ Reply to Thread
Results 1 to 5 of 5

Sumif multiple text values

  1. #1
    Registered User
    Join Date
    05-07-2012
    Location
    Boston MA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Sumif multiple text values

    I would like to sum the values of cells in a column where corresponding cells in another column equal any one of five or so text values.

    Any help is greatly appreciated.

    Thank you.

    _t

  2. #2
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Sumif multiple text values

    Have you tried a LOOKUP function combined with a SUM function?
    When I say semicolon, u say comma!

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Sumif multiple text values

    Hi,

    =SUMPRODUCT(SUMIF(range_to_sum,range_which_holds_5_criteria,range_in_which_to_search_for_criteria))

    e.g.

    =SUMPRODUCT(SUMIF($E$1:$E$8,$A$1:$A$5,$D$1:$D$8))

    Regards
    Click * below if this answer helped

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

  4. #4
    Registered User
    Join Date
    05-07-2012
    Location
    Boston MA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Sumif multiple text values

    Thanks XOR LX.

    That did the trick except the ranges seemed to be swapped.

    =SUMPRODUCT(SUMIF(range_in_which_to_search_for_criteria,range_which_holds_5_criteria,range_to_sum))

    Seemed to function as desired.

    Thanks again!

    _t

  5. #5
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Sumif multiple text values

    Ah, um...yeah! Just testing you!

    (I never liked the order of syntax for this formula anyway!)

    Well spotted!

+ 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. SUMIF Cell contains any text from an range of values
    By inigam80 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2012, 11:20 AM
  2. SUMIF Multiple values within Column
    By rstrosch in forum Excel General
    Replies: 1
    Last Post: 12-11-2011, 04:17 PM
  3. Multiple sumif text contains
    By joshhales in forum Excel General
    Replies: 10
    Last Post: 03-31-2011, 10:30 AM
  4. Multiple values in one cell for sumif function
    By bernard.x in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-08-2010, 08:41 AM
  5. SUMIF - Text & Values
    By REL in forum Excel General
    Replies: 6
    Last Post: 07-24-2009, 12:01 PM

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