There are two approaches:

1. Use the COUNTIF() formula
=COUNTIF(A:A,1)
will tell you how many time 1 appears in column A


2. Use a Pivot Table. This can tell you how many times ALL numbers appear
in column A. See: http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary''s Student


"Taxman" wrote:

I am trying to construct a formula to count the occurance of all numbers
between 0 and -20000 in a column, I just can´t get it right. I´ve tried
looking in the help section but I just don´t get it. I am using Excel 2003
standard edition. Since I am using a swedish version I won´t bother you with
any of my examples