find 2 values if exist in the same time in line

[iulinas]

Hi,


I have many lines:

for example:




1,45,49,32,7,8
3,23,12,33,1,2

----------------

How can I verify if two numbers( for example:5 and 7 in the same time) appear in line? And if appear I want to count this thing.
Thanks

[FDibbins]

Hi, welcome to the forum

If you know what numbers you need to test for, you can use something like this...
for 1 number...
=COUNTIF(A1:J1,5)
For more than 1 number...
=SUM(COUNTIF(A1:J1,{5,7}))

[iulinas]

For more than one number doesn't work!!!

1 2 7 4 5 6 0 for 0 I put:=COUNTIF(A3:F3;{5,7})

5 and 7 appear in the same time in line(third ,fifth )
Where I wrong?

[iulinas]

=AND(COUNTIF(A3:F3;5);COUNTIF(A3:F3;7))

I find

[FDibbins]

Where I wrong?

My post #2 gave 2 options, 1 for a single value and the 2nd fornula for 2 or more values