Frequency of Count Ifs

		Microsoft Office Forums > Microsoft Excel > Excel
Frequency of Count Ifs

FAQ

Thread Tools

Display Modes

01-30-2017, 10:34 AM

jeffreybrown jeffreybrown is offline

Windows Vista Frequency of Count Ifs

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

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)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:25 AM.