+ Reply to Thread
Results 1 to 11 of 11

COUNTIF / SUMS where distinct Criteria is MET

Hybrid View

  1. 01-24-2020, 12:56 PM #1
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,690

    Re: COUNTIF / SUMS where distinct Criteria is MET

    this for row 3, test 1 cases...=SUMPRODUCT(('Working Detail'!$G:$G=R$1)*('Working Detail'!$H:$H=0)*('Working Detail'!$I:$I>0),'Working Detail'!$I:$I)
    this is for row 16, test 2 cases... =SUMPRODUCT(('Working Detail'!$G:$G=R$1)*('Working Detail'!$H:$H>0)*('Working Detail'!$I:$I=0),'Working Detail'!$H:$H)
    think I got them all for you.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  2. 01-24-2020, 01:16 PM #2
    rz6657
    rz6657 is offline
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    372

    Re: COUNTIF / SUMS where distinct Criteria is MET

    Thx, working good. I think the only 1 left is row 5 where it has 2 conditions and sums both columns H and I once criteria is met---
    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. [SOLVED] Count Distinct with a second Criteria
    By locopete999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2019, 11:37 AM
  2. How to search sums of table, with multiple criteria AND less criteria than needed
    By HereComesTheBoom in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-25-2018, 02:42 PM
  3. Countif Distinct and Criteria HELP!!!
    By deadlyliquidxxx in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2015, 04:22 PM
  4. How to make Endless formula countif and sums??
    By Da-Kaiser in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-10-2013, 04:42 PM
  5. Distinct COUNTIF
    By TheNewUnion in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-19-2012, 06:27 AM
  6. Formula - Count distinct / Countif??
    By Africa in forum Excel General
    Replies: 3
    Last Post: 02-29-2012, 11:24 AM
  7. Multiple Countif Sums
    By Darran in forum Excel General
    Replies: 2
    Last Post: 06-01-2006, 06:30 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