#1
|
|||
|
|||
count formula to count based on multiple criteria and return unique rows
I wrote a formula below to count unique rows using nine non-adjacent criteria ranges from the source data. The unique rows are based on the values in column-G in the source data, that is, if there are duplicate items in the columnG the formula just looks at one. Criteria ranges PmtTypeRng and DelayTypeRng have a set of multiple items/criteria.
The formula sadly return null. Not sure what i'm doing wrong, will appreciate any expert help to solve this.. =SUM(IF(FREQUENCY(IF((DateMonthRng=$C$4)*(ZoneRng= $E$4)*(ClientRng=$C2)*(ClientAccRng=$D2)*(DistroRn g=$E2)*(PaymtDelbyRng="Customer")*(PmtTypeRng={"Di rectDebit","Cash","CreditCard"})*(DebtAgeRng={"5-day","10-day","20-day"}))*(PaymtEffect_Rng="Debit"),(MATCH(G2,G:G,0) ),MATCH(G2,G:G,0))>0,1,0)) Thanks |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count Unique Instances of Multiple Strings Using Wildcards | robnun | Word VBA | 14 | 12-05-2020 08:50 AM |
I need to count based on multiple criteria in multiple columns | rachaels54 | Excel | 1 | 04-18-2017 03:20 PM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Getting the Count formula to count all rows | Jennifer Murphy | Word Tables | 11 | 08-23-2016 09:37 PM |
Count unique values that match 2 or more criteria | caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |