Excel function to return if 2 out of 3 criteria met 1

[walla07]

Hi,

Please could someone help me with the wording for an Excel function that would return a value if 2 out of 3 criteria is met for a given value.

A specific example is three criteria, i.e. 10, 12 and 15 and a value of 14. The test would be if 14 is greater than 2 out of 3 of the criteria. It is, so a value (x) would be returned.

I've tried to use the COUNTIF and OR functions but am having trouble getting Excel to recognise COUNTIF(range,">value").

Any help would be much appreciated.


Thank you

 

[KenWright]

=SUMPRODUCT(--(E1>$A$1:$C$1))>=2

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[walla07]

Thanks KenWright

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------