Posted to microsoft.public.excel.newusers
|
|
I have two columns 1 & 0 and want to choose those cell with 1
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.
|