possibly a bit of a numpty question:

Let's say I have a very long column of numbers; random numbers between 1 and 100

And let's say I want to highlight the numbers which are under, say, 50.... no problem, use conditional formatting or whatever it's called in the English version of Excel (I have the German version here at work).

But how about if I want to automatically count up how many of the numbers in this column have fulfilled the condition, i.e. without counting them out manually.

Ideally I could do with a figure at the bottom of the column of numbers telling me how many of them have a value less than "x" (won't always be 50!)

Any ideas ? Any input would be greatly appreciated!