This can be done two ways since you are dealing with 1's and 0's. I assume
you have two columns with these numbers in them. I will use Columns A & B
and Rows 1-6

1st Way: =COUNTIF(A1:B6,"=1")

2nd Way: Since you are looking for all the 1's, you could also SUM them and
get the same answer: =SUM(A1:B6)

"Dr. saeed mohtasham nia" wrote:

Dear friends: I have two set of data only 1 & 0. and want to use countif
function
to choose those cells with only 1.
my data is he
1 0
0 1
1 1
0 1
1 0
1 1

I want to count the cells containing only 1 1
please helpme. thanks.