+ Reply to Thread
Results 1 to 25 of 25

Trying Sumproduct with multiple criteria 1) greater than, or 2) partial text

Hybrid View

  1. 08-19-2013, 11:07 AM #1
    Groovicles
    Groovicles is offline
    Forum Contributor
    Join Date
    07-29-2013
    Location
    Oshawa
    MS-Off Ver
    Excel 2010
    Posts
    660

    Re: Trying Sumproduct with multiple criteria 1) greater than, or 2) partial text

    Hi Tony,

    Total count should be 5.
    Reply With QuoteRegister To Reply
  2. 08-19-2013, 11:11 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Trying Sumproduct with multiple criteria 1) greater than, or 2) partial text

    Quote Originally Posted by Groovicles View Post
    Hi Tony,

    Total count should be 5.
    OK, so you want to count a ROW if any cell on that row meets the condition.

    Try this...

    =SUMPRODUCT(SIGN((A1:A6>625)+(LEFT(B1:B6,2)="CA")+(LEFT(C1:C6,2)="CA")))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sumproduct with multiple criteria including partial search
    By Groovicles in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-29-2013, 01:30 PM
  2. Excel 2007 : SUMPRODUCT() partial criteria lookup using LEFT() and INDIRECT() - Fails to Load Range
    By Monobi in forum Excel General
    Replies: 1
    Last Post: 07-10-2012, 07:39 AM
  3. hlookup and multiple criteria sumproduct to analyze text and dates
    By cdl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-05-2008, 09:12 AM
  4. sumproduct partial text count
    By Ribeye in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2006, 02:50 PM
  5. Sumproduct with multiple text criteria
    By Robert in forum Excel General
    Replies: 2
    Last Post: 12-06-2005, 01:45 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1