Hello everybody ,
I find myself confronted to a wierd problem ;
I wish to count in a list all the unique values that meet four different
criterias .
I have found thanks to C Pearson's site the formula to count all the
unique values in a liste :
=SOMME(SI(FREQUENCE(EQUIV(rangeD;rangeD;0);EQUIV(rangeD;rangeD;0))>0;1)) .
But this is not enough I still need to add four different conditions that
are :
{sum(rangeA>A1)*(rangeB<B1)*(rangeC=C1)*(rangeD=D1)}
I have tried to add up these two formulas but it doesn't work .
Any ideas ?
Many thanks
dvd
I find myself confronted to a wierd problem ;
I wish to count in a list all the unique values that meet four different
criterias .
I have found thanks to C Pearson's site the formula to count all the
unique values in a liste :
=SOMME(SI(FREQUENCE(EQUIV(rangeD;rangeD;0);EQUIV(rangeD;rangeD;0))>0;1)) .
But this is not enough I still need to add four different conditions that
are :
{sum(rangeA>A1)*(rangeB<B1)*(rangeC=C1)*(rangeD=D1)}
I have tried to add up these two formulas but it doesn't work .
Any ideas ?
Many thanks
dvd