i'm not sure i've expressed my problem clearly.

say in column A i have the values 1,2,3,4 and 5 so it may run like
this
5
1
1
2
1
3
3
4
1
4

Then i do a COUNTIF(A:A,"1") which gives me a total of 4.

So now i want to do the following with 2 and then 3 and then 4 and so
on.

Which wouldn't be so bad but my range of numbers goes on to over 100 so
it would be easier if somehow i could increment the value the countif
function is looking for, rather than typing in each countif on the
column A

Cheers,

John