Thanks:  0
Likes:  0

# Thread: Unique values with multiple conditions

1. 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
I have tried to add up these two formulas but it doesn't work .

Any ideas ?

Many thanks

dvd

2. 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
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/viewtop...c=3267&forum=2

If you need anymore let me know.

3. 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
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/viewtop...c=3267&forum=2

If you need anymore let me know.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•