You STILL have not explained why your first formula is not suitable
for you - you said it works perfectly for you.

Pete

On Jul 2, 4:05*pm, ytayta555 wrote:
A good day !

I have this function *:

=AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D 1;D3;D5)<=1;COUNT(E1;E3;E*5)<=1;COUNT(F1;F3;F5)<=1 ) * ;

this function let me to know if every one of the 5 COUNT functions
have the result the value <=1;
(this is what I need !!, not to count everyone of the five count
functions the value only *<=1!!!; it must work like Count functions,
not like a Countif function *{Countif <=1 }) ;

The last result of this this function I want to show me if all *5
Count functions result is *<=1 ;

This function work perfect for me , but I need very very strong a
perfect equivalent for this function (why I need this , it's a long
story ...) ,made with another functions .

I get some variants , but them doesn't work ;(but I think the solution
is somewhere here arround) :

=COUNT(INDEX(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0)/
ISNUMBER(B4:AH83),0))
or

=SUMPRODUCT(ISNUMBER(MATCH(ROW(B4:AH83),
{4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0))*
ISNUMBER(B4:AH83))
or

=SUMPRODUCT(ISNUMBER(MATCH(ROW(B1:F5), {1,3,5},0))*(B1:F5<=1))

Can you help me to get a function which do the same thing like this
function ?

Thanks very much for your time .