Count, for values within a range?

[jodleren]

Hi all

I have some statistics for production, where I get a table full of
numbers.
I run some basic statistics on them, but I also want to count values
less than 25.

It is like count(a:d), but only where the value is less than 25....
how can I do that?

WBR
Sonnich

 

[Pete_UK]

Try this:

=COUNTIF(A,"<=25")

Hope this helps.

Pete

 

[jodleren]

Nope, this just gives a message, that "the formula contains an error",
and jumps to the D

Setting is a A110 does not help, either with " around.

WBR
Sonnich

 

[Peo Sjoblom]

Well you probably use a different delimiter, in place of the comma put a
semi colon there

;




--


Regards,


Peo Sjoblom


Nope, this just gives a message, that "the formula contains an error",
and jumps to the D

Setting is a A110 does not help, either with " around.

WBR
Sonnich

 

[Pete_UK]

Perhaps your system uses semicolons instead of commas as delimiters.
Try it this way:

=COUNTIF(A;"<=25")

or like this to reduce the range:

=COUNTIF(A110;"<=25")

Hope this helps.

Pete

 

[jodleren]

Well you probably use a different delimiter, in place of the comma put a
semi colon there

;

That works. Why is there so big differences between semicolon and
comma?
Why would comma work for you? Local settings?

WBR
Sonnich

 

[Pete_UK]

Yes, these are settings local to your region. Many European countries
use a comma as a decimal point, so having commas in formulae could be
very confusing.

Pete

 

[Peo Sjoblom]

Yes, US and UK settings use comma as delimiter and Many European countries
use semi colon.

--


Regards,


Peo Sjoblom

Well you probably use a different delimiter, in place of the comma put a
semi colon there

;

That works. Why is there so big differences between semicolon and
comma?
Why would comma work for you? Local settings?

WBR
Sonnich

 

[herochenna]

Visit www.ExcelGoodies.Com