View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ytayta555 ytayta555 is offline
external usenet poster
 
Posts: 247
Default FUNCTION in easyer format

Have a good time !

I have this function :
=AND(COUNT(Z4;Z5;Z6;Z7;Z8;Z9;Z10;Z11;Z12;Z13;Z14;Z 15;Z16;Z17;Z18)<=1;COUNT(AA4;AA5;AA6;AA7;AA8;AA9;A A10;AA11;AA12;AA13;AA14;AA15;AA16;AA17;AA18)<=1;CO UNT(AB4;AB5;AB6;AB7;AB8;AB9;AB10;AB11;AB12;AB13;AB 14;AB15;AB16;AB17;AB18)<=1;COUNT(AC4;AC5;AC6;AC7;A C8;AC9;AC10;AC11;AC12;AC13;AC14;AC15;AC16;AC17;AC1 8)<=1;COUNT(AD4;AD5;AD6;AD7;AD8;AD9;AD10;AD11;AD12 ;AD13;AD14;AD15;AD16;AD17;AD18)<=1;COUNT(AE4;AE5;A E6;AE7;AE8;AE9;AE10;AE11;AE12;AE13;AE14;AE15;AE16; AE17;AE18)<=1;COUNT(AF4;AF5;AF6;AF7;AF8;AF9;AF10;A F11;AF12;AF13;AF14;AF15;AF16;AF17;AF18)<=1;COUNT(A G4;AG5;AG6;AG7;AG8;AG9;AG10;AG11;AG12;AG13;AG14;AG 15;AG16;AG17;AG18)<=1;COUNT(AH4;AH5;AH6;AH7;AH8;AH 9;AH10;AH11;AH12;AH13;AH14;AH15;AH16;AH17;AH18)<=1 ;COUNT(AI4;AI5;AI6;AI7;AI8;AI9;AI10;AI11;AI12;AI13 ;AI14;AI15;AI16;AI17;AI18)<=1;COUNT(AJ4;AJ5;AJ6;AJ 7;AJ8;AJ9;AJ10;AJ11;AJ12;AJ13;AJ14;AJ15;AJ16;AJ17; AJ18)<=1;COUNT(AK4;AK5;AK6;AK7;AK8;AK9;AK10;AK11;A K12;AK13;AK14;AK15;AK16;AK17;AK18)<=1)

Can somebody give me an equivalent for this function , to be more
simply ?

1.) Every count function must work like an normal Count function, not
like COUNTIF function with criteria<=1 !
2.)Like this doesn't help me
(COUNT(AG4:AG18)<=1;COUNT(AK4:AK18)<=1;........... .), because this
function is for exemple , I must made and built milions af this
function , with references in combinatoric order !
3.) Every count function is a combination of 15 numbers , used for an
lotto statistic database , it doesn,t work to count
{ COUNT(AH4;AI4;AJ4;AK4)................., the drow is in an one
column , not in one row .

Thanks very much for your amability and for your time !