Hi folks

How do you ask excel not to count a cell if a criteria is not met?

For example:

let's say A1 = 5 B1=6 C1=2 D1=1

and you want the count function not to count a cell if it is less than 5, so in this example, it should return a value of 2? How do nest it with "if" function? I don't know how to do this..

Any pointers would be greatly appreciated.

Thanks!

R Green