How to Countif filtered data

**micope21** · 04-06-2016, 12:20 PM

Hi

E4

Formula:

=SUM(IF(FREQUENCY(IF(B6:B45<>"",IF($B$6:$B$45="2010 - Q2",MATCH($B$6:$B$45,$B$6:$B$45,0))),ROW($B$6:$B$45)-ROW($B$6)+1),1))

This is array formula. Press same time (Ctrl+Shift+Enter) till you see both end{}. DO NOT PRESS ENTER ON IT OWN? Otherwise it won't work

**thaimic** · 04-06-2016, 09:22 PM

Hi micope21,
thank you so much ,
so how can I count all data in column B with no duplicates data.
for my example the result should be by 4

**Phuocam** · 04-07-2016, 08:12 AM

Originally Posted by thaimic

for my example the result should be by 4

or try this...
=SUMPRODUCT((B6:B45<>"")/COUNTIF(B6:B45,B6:B45&""))

Re: How to Countif filtered data