Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2017, 07:05 AM
keeble keeble is offline Frequency of Count Ifs Windows 10 Frequency of Count Ifs Office 2010 32bit
Novice
Frequency of Count Ifs
 
Join Date: Jan 2017
Posts: 2
keeble is on a distinguished road
Question 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)
Reply With Quote
  #2  
Old 01-30-2017, 10:34 AM
jeffreybrown jeffreybrown is offline Frequency of Count Ifs Windows Vista Frequency of Count Ifs Office 2007
Expert
 
Join Date: Apr 2016
Posts: 650
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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)
Reply With Quote
  #3  
Old 01-31-2017, 08:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Frequency of Count Ifs Windows 7 64bit Frequency of Count Ifs Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,577
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote
  #4  
Old 02-01-2017, 09:03 AM
keeble keeble is offline Frequency of Count Ifs Windows 10 Frequency of Count Ifs Office 2010 32bit
Novice
Frequency of Count Ifs
 
Join Date: Jan 2017
Posts: 2
keeble is on a distinguished road
Default

This works thank you so much!
Reply With Quote
  #5  
Old 02-01-2017, 10:33 AM
jeffreybrown jeffreybrown is offline Frequency of Count Ifs Windows Vista Frequency of Count Ifs Office 2007
Expert
 
Join Date: Apr 2016
Posts: 650
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Happy to hear it helped you out and you're welcome.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Frequency of Count Ifs 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
Frequency of Count Ifs 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft