Microsoft Office Forums - View Single Post - [Solved] Frequency of Count Ifs

Thread: [Solved] Frequency of Count Ifs

View Single Post

Old

01-30-2017, 10:34 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown 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