5,5,6,4,6,5,6,7,7,2 Group of data, I want to found court of A1:A10, >5 and <=7
W Winnie Nov 13, 2006 #1 5,5,6,4,6,5,6,7,7,2 Group of data, I want to found court of A1:A10, >5 and <=7
B Bob Phillips Nov 13, 2006 #2 =COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">7") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=COUNTIF(A1:A10,">5")-COUNTIF(A1:A10,">7") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
