Count, for values within a range?

  • Thread starter Thread starter jodleren
  • Start date Start date
J

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
 
Nope, this just gives a message, that "the formula contains an error",
and jumps to the D

Setting is a A1:D10 does not help, either with " around.

WBR
Sonnich
 
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 A1:D10 does not help, either with " around.

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

=COUNTIF(A:D;"<=25")

or like this to reduce the range:

=COUNTIF(A1:D10;"<=25")

Hope this helps.

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

;
Click to expand...

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

WBR
Sonnich
 
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
 
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

;
Click to expand...

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

WBR
Sonnich
 
Back
Top