Results 1 to 11 of 11

Sumif with multiple criteria of text containing certain words

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2016
    Location
    London
    MS-Off Ver
    MAC
    Posts
    3

    Sumif with multiple criteria of text containing certain words

    Hi all!

    I am currently working on a document where I would like to sum the monthly Google searches for certain group of words. For example, for a particular topic like brands, I have a long list of different brands and would like to add the volume searches of all of them.
    I am currently using the following formula:

    =SUM(SUMIF(A3:A1510,{"*best*","*reviews*","*top*","*good*","*recommended*","*effective*"},B3:B1510))

    As some of my lists are very long, I would like to avoid having to type each keywords.
    Also, these are not exact match but I am looking for all cells containing those words or expressions.
    Attached, you will find my file in case I did not explain it clearly enough!

    As I did not find the answer to my question while doing research online, I was hoping maybe you could help?

    Many thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. SUMIF problem looking for specific words within text
    By james19 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-08-2016, 10:03 AM
  2. SumIF with multiple columns with non-specific text criteria
    By Funky_Finance in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-22-2014, 02:19 PM
  3. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  4. Replies: 4
    Last Post: 03-03-2013, 02:35 PM
  5. [SOLVED] SumIf / SumIfs with multiple Contains Text criteria
    By theweirdone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2012, 05:22 AM
  6. SUMIF with multiple criteria, text and numerical
    By Radman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-24-2008, 12:23 PM
  7. [SOLVED] is there any way to have multiple TEXT criteria in a 'sumif' funct
    By datasorter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2006, 02:20 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