Hi,

i think from these 2 examples you should be able to work out the other
formula.

=COUNTIF(A1:A20,"<10")
=COUNTIF(A1:A20,"=10")-COUNTIF(A1:A120,"20")


Mike


"mark (plymouth)" wrote:

Hi All,
i am trying, without success to creat a formula to do the following:
i have a series of values in a column and want to show how manay time a
number occurs within a range from the list.
i.e. in my list i have 12,17,23,24,25,23,24,22,26,43,32,32,33,44,53
i then want to display the number of instance there is an occurance of:
<10, 10-20, 21-30, 31-40, 41-50, 51
I would appreciate any assitance you might offer.

Thanks