+ Reply to Thread
Results 1 to 4 of 4

Using SUMPRODUCT if cells contain this text

  1. 01-15-2020, 11:36 AM #1
    PK1103
    PK1103 is offline
    Registered User
    Join Date
    01-15-2020
    Location
    Orlando, FL
    MS-Off Ver
    2013
    Posts
    2

    Using SUMPRODUCT if cells contain this text

    How do I use SUMPRODUCT to lines that contain certain text?

    Eg. if cells contains "Rent" then sumproduct by month, see attached for detail.


    Capture.PNG
    Reply With QuoteRegister To Reply
  2. 01-15-2020, 11:40 AM #2
    XLent
    XLent is offline
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Using SUMPRODUCT if cells contain this text

    in this instance you could use:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 01-15-2020, 11:41 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Using SUMPRODUCT if cells contain this text

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 01-15-2020, 11:44 AM #4
    PK1103
    PK1103 is offline
    Registered User
    Join Date
    01-15-2020
    Location
    Orlando, FL
    MS-Off Ver
    2013
    Posts
    2

    Re: Using SUMPRODUCT if cells contain this text

    That works, THANK YOU SO MUCH!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula Problem: SUMPRODUCT (Count cells with text, excluding blanks and two names)
    By Dannyfranklin123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2018, 03:42 AM
  2. [SOLVED] Code is putting formatting cells as text so that VB function and Sumproduct #Value! error
    By KG869 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2017, 05:51 PM
  3. Sumproduct using indirect and with some text cells in array
    By Manwithaplan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-19-2016, 12:46 AM
  4. Using sumproduct when array contains some cells with text
    By Manwithaplan in forum Excel General
    Replies: 9
    Last Post: 12-17-2016, 01:15 AM
  5. [SOLVED] Exclude cells containing text from SUMPRODUCT function
    By Uomoviso in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-17-2016, 09:20 AM
  6. [SOLVED] Unable to use SUMPRODUCT to count multiple criteria with cells with 'specific text string'
    By BDavis in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2013, 05:32 PM
  7. SUMPRODUCT: Help with text #VALUE, and INDIRECT(SUMPRODUCT)
    By rasonline in forum Excel General
    Replies: 6
    Last Post: 03-09-2011, 08:01 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1