Count(..)

[R Green]

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

 

[Bob Phillips]

=COUNT(IF(A11>=5,A11))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

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

 

[Beege]

R Green

=COUNTIF()

?

Beege

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

 

[Peo Sjoblom]

=COUNTIF(A11,">=5")

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


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

 

[R Green]

Thanks to ALL!

R Green
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