Function Countif problem in Numbers for Mac

Spark,

the countif() function can conditionally count based on a single boolean condition.

You have specified "... find all number above and below a particular number..". The AND portion of your requirement implies you want to count when two conditions are met:

1) number X is greater than A

2) number X is less than B

in this case you want to use countifs() like this:

=countifs(<value1>, <cond1>, <value2>, <cond2>)

for your problem <value1> and <value2> are the same and

<cond1> is the concatenation of the string containing the boolean test "<10" (change the value 10 as needed)

<cond2> is the concatenation of the string containing the boolean test ">5" (change the value 5 as needed)

So...

=countifs(<cells with X>, "<10", <cells with X>, ">5")

this will count when the cells with X are greater than 5 AND less than 10

This is very similar to a post a few days ago that has some screen shots to show how to do this with multiple criteria and ranges.

http://tinyurl.com/kpwt75o

Jason

Hi Sparkgapper,

An old timer on the forum once told me that he searches with google focused on the forum rather than using the built in search because it is so lame. I, too get better, more thorough results using an outside search engine. It is too bad. It has improved some in the past 6 months or so.

quinn

Quinns suggestion is excellent, but Just in case some people don't know how to restrict your google search here is an example using countif:

Go to google and enter this.....

countif site:discussions.apple.com

jason