Results 1 to 11 of 11

Using SUMIF with a keyword as part of the criteria

Threaded View

cdeguzman Using SUMIF with a keyword as... 03-27-2014, 10:13 AM
Jonmo1 Re: Using SUMIF with a... 03-27-2014, 10:16 AM
cdeguzman Re: Using SUMIF with a... 03-27-2014, 10:18 AM
Ace_XL Re: Using SUMIF with a... 03-27-2014, 10:17 AM
Tony Valko Re: Using SUMIF with a... 03-27-2014, 10:18 AM
cdeguzman Re: Using SUMIF with a... 03-27-2014, 10:25 AM
Tony Valko Re: Using SUMIF with a... 03-27-2014, 10:30 AM
Jonmo1 Re: Using SUMIF with a... 03-27-2014, 10:20 AM
cdeguzman Re: Using SUMIF with a... 03-27-2014, 10:25 AM
Tony Valko Re: Using SUMIF with a... 03-27-2014, 10:22 AM
Jonmo1 Re: Using SUMIF with a... 03-27-2014, 10:27 AM
  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    19

    Using SUMIF with a keyword as part of the criteria

    Happy Days to all - I am looking to get help with using a keyword search as part of a criteria for a SUMIF statement.

    I have attached my working copy for you to see.

    I would like G2 (I am only using September at this point) to populate the sum of C2:C8, only if D2:D8 contains the word Education. Similar for Government and below with their respective words.

    I am not sure if the word was always at the beginning would help, but that is how it would be input in the worksheet.

    Thank you for any help!
    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. Replies: 6
    Last Post: 03-18-2014, 11:16 AM
  2. [SOLVED] Sumif Keyword
    By rick434 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-23-2013, 12:53 AM
  3. Filter List by Keyword & copy the result in column by keyword as header
    By kitunga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2013, 07:16 AM
  4. Replies: 2
    Last Post: 07-13-2012, 04:02 AM
  5. Insert text in Cell A1 based on keyword criteria
    By twlove@ontuet.com in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-13-2006, 12:10 PM

Tags for this Thread

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