View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default OLD PROBLEM without SOLUTION

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;E5)<=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 .