Some interpretation needed here!
OP's next to last line reads:
<<<"I want to count the cells containing only 1 1 "
Which I *and* JMB take to mean "matching pairs of columns".
With JMB's formula being more concise then my suggestion, until I checked,
It really bothered me that a Countif would *also* perform to *my*
interpretation of the question.
Glad to see that it was your understanding of the problem and not my
ineptitude, where I couldn't recognize a Countif solution as opposed to a
Sumproduct solution.<vbg
You do that to me quite often, where I'm ready to post a suggestion, but you
beat me to it, with a more fitting solution, making me glad that I'm not as
fast as you.
Didn't you mention somewhere that you have files (solutions) saved, where
you just "copy & post"?<bg
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Bob Phillips" wrote in message
...
or even =COUNTIF(A1:B6,1)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"JMB" wrote in message
...
If the data is only 1's and 0's:
=SUMPRODUCT(A1:A6, B1:B6)
"Ragdyer" wrote:
Try this:
=SUMPRODUCT((A1:A6=1)*(B1:B6=1))
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
--------------------------------------------------------------------------
-
"Dr. saeed mohtasham nia" <Dr. saeed mohtasham
wrote in message
...
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.