count number of instances a number occurs
Thanks very much, that works fine.
"Mike H" wrote:
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
|