A.=COUNTIF(B2:B11,B2)>1 B.=countif(B2:B11,B2) C.=COUNTIF($B$2:$B$11,B2)<>1 D.=COUNTIF($B$2:$B$11,B2) E.=COUNTIF($B$2:$B$11,B2)>1
A.=COUNTA(0,1,2) B.=COUNT(O,1,2) C.=COUNT(1) D.=COUNT("1","a","b") E.=COUNTA("1","a","b")
A.Sumif B.Count C.Countif D.Sumifs E.Countifs