#1
|
|||
|
|||
Frequency of Count Ifs
I have the below formula which works correctly however I have duplicates in rows which I need it to deduct, any ideas what I can add to get it to do this without?
=SUM(COUNTIFS($A$28:$A$224,"Accepted",$C$28:$C$224 ,"Tier 1")) So for example I have the below, the number I need to get to is 4 accepted tier 1 companies: Accepted Mr Smith Tier 1 Company A Accepted Mr Reynolds Tier 1 Company A Accepted Miss Cole Tier 1 Company B Accepted Mr x Tier 1 Company C Accepted Mrs Y Tier 1 Company C Accepted Mr Z Tier 1 Company D Note I cannot just use the frequency count as I need it to look for specific things across a range of data. Ive been racking my brains so anyone that can help with this would appreciate it! Thanks :0) |
#2
|
|||
|
|||
How about use a helper column, so in E1 copied down...
=COUNTIFS($A$1:A1,A1,$C$1:C1,C1,$D$1 : D1,D1) Now if F1 count the 1's for the unique... =COUNTIF(E:E,1) |
#3
|
||||
|
||||
Moved to non-programming forum
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
This works thank you so much!
|
#5
|
|||
|
|||
Happy to hear it helped you out and you're welcome.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help calculating frequency of digits | laucn | Excel | 2 | 06-08-2015 07:50 AM |
Formula to calculate Frequency | lwls | Excel | 1 | 03-30-2015 05:40 AM |
Trying to count frequency | borninscorpio | Excel | 4 | 07-31-2013 12:44 AM |
Frequency of a name | bryant03 | Excel | 1 | 06-27-2012 10:21 AM |
How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |