Unique values with multiple conditions

[vddavid]

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

 

[Ian Mac]

On 2002-04-04 05:38, vddavid wrote:
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

Not sure of the french equivalents, but:
try this link to an answer Aladin gave me which I think is similar to what you need.

http://www.mrexcel.com/board/viewtopic.php?topic=3267&forum=2

If you need anymore let me know.

 

[Ian Mac]

On 2002-04-04 05:38, vddavid wrote:
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

Not sure of the french equivalents, but:
try this link to an answer Aladin gave me which I think is similar to what you need.

http://www.mrexcel.com/board/viewtopic.php?topic=3267&forum=2

If you need anymore let me know.