Count(..)

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

=COUNT(IF(A1:D1>=5,A1:D1))

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)

"R Green" <[news]@wowsat.com> wrote in message
news:[email protected]...
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

=COUNTIF()

?

Beege

"R Green" <[news]@wowsat.com> wrote in message
news:[email protected]...
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

=COUNTIF(A1:D1,">=5")

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"R Green" <[news]@wowsat.com> wrote in message
news:[email protected]...
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

Thanks to ALL!

R Green
"R Green" <[news]@wowsat.com> wrote in message news:[email protected]...
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