Forum Discussion
count the unique values with 2 condition
Hello, want to ask .. how to count the country who reach the "book/detail" url with the unique IP .. thank you ..
If collect formulas that could be couple of regular (non-array) ones like
=SUM(INDEX(($B$2:$B$8=F4)*($C$2:$C$8=G4)*1/COUNTIF($A$2:$A$8,$A$2:$A$8),0,1))
and
=SUMPRODUCT(($B$2:$B$8=F8)/COUNTIF($A$2:$A$8,$A$2:$A$8))
Please see attached