aantal.als - Countif

Hi


I have a field from B11 to U35 containing numbers and on this field I need to do a number of operations. One of them is that I need to automaticly count how many numbers there are below a certain value that is put in C40 ( for example I need to count how many numbers there are smaller than 50 so 50 is the number in C40.

I'm dutch and in the dutch version the function is called "aantal.als" and it works like this:
=AANTAL.ALS(B11:U35;=C40)
then it counts how many numbers there are in B11:U35 that equal the value in C40 but what I need is this:
=AANTAL.ALS(B11:U35;<C40)
and it's the "<" "smaller than" that gives an error.

Can anyone help..?

thx

sanne

Hi,

Please Login or Register  to view this content.

HTH
Carim

my god man your brilliant , this is something we have to do in at our college that's part of our exam ( prepare an automated sheet for analysis of certain data) and we've been searching on that small problem for a week with 10 guy's or something
I'll bet there gonna feel kind of stupid now..

Well... excel isn't part of our education

I wish I could explain our other problem in english to

It's something like: In a certain range D38 to D48 we search the highest value with =MAX(D38:D48) wich is no problem at all but the you get a value and we actualy need the number in the cell left of the cell with that highest value. So when the highest value is in cell D40 we actually need the value from cell C40 ??

Well thanks anyway
sanne

that's impressive man thanks a lot
In dutch apparently you have to translate match and change , into ; and than it works:

=INDEX(D39:E58;VERGELIJKEN(MAX(E39:E58);E39:E58;0);1)

great

As I said my Dutch is very limited ...

Glad your problems are fixed ...

Thanks for the feedback

Carim