+ Reply to Thread
Results 1 to 4 of 4

Sumproduct v Count IFs (or both)

  1. 04-23-2015, 09:18 AM #1
    Matt1998
    Matt1998 is offline
    Registered User
    Join Date
    04-03-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Sumproduct v Count IFs (or both)

    Hello

    I have an overview sheet where I look at a data sheet.

    I need to count per customer (Customer 1, Customer 2) the number of "Complete" reports within a month (Data Range) which are <= 7.

    I have attached an example

    Help is always appreciated.
    Thanks
    Matt
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-23-2015, 09:30 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Sumproduct v Count IFs (or both)

    What does <=7 mean?
    <=7 what ?
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 04-23-2015, 09:33 AM #3
    Matt1998
    Matt1998 is offline
    Registered User
    Join Date
    04-03-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Sumproduct v Count IFs (or both)

    Less than or equal to 7. Column B "Time" - Measured in Days.
    Reply With QuoteRegister To Reply
  4. 04-23-2015, 09:59 AM #4
    bhenlee
    bhenlee is offline
    Valued Forum Contributor
    Join Date
    02-07-2013
    Location
    Philippines
    MS-Off Ver
    Excel Online; 365
    Posts
    610

    Re: Sumproduct v Count IFs (or both)

    Try this formula:

    =COUNTIFS(Data!$C$2:$C$27,Overview!$A4,Data!$A$2:$A$27,"Complete",Data!$B$2:$B$27,"<=7",Data!$D$2:$D$27,">="&Overview!B$3,Data!$D$2:$D$27,"<"&Overview!C$3)
    If I've helped U pls click on d *Add Reputation
    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. Count SUMPRODUCT Members / Average of SUMPRODUCT
    By Shingaru in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-10-2014, 03:59 PM
  2. SUMPRODUCT Count
    By bhenderson in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2011, 05:33 PM
  3. Using a SumProduct Count to find a SumProduct Total?
    By XL021710 in forum Excel General
    Replies: 3
    Last Post: 02-18-2010, 08:31 AM
  4. sumproduct to count
    By profector in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2008, 05:43 PM
  5. Count if and Sumproduct
    By Brento in forum Excel General
    Replies: 2
    Last Post: 06-20-2006, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1