stats for a set of numbers.

  • Thread starter Thread starter jc calling
  • Start date Start date
J

jc calling

i have a set of number that are from 1 to 50 in a number of fields grouped
together.
the numbers are in fields from lets say a1 to h21 for instance. each field
has a number from 1 to 50
i have got at the bottom of this list a set of numbers from 1 to 50 and each
has an empty field beside this number for a count number to show me how many
time that number shows up in the set of number at the top of the chart.
and i want to have a formula that counts the number of '1's and shows up in
the 'number of ones' fields and so on though all the numbers.

i have tried but can not work it out.

hope someone out there knows what i need.

thank you in advance for any help


Jason
 
Hello,

Suppose you start your number with A24 write this formula to B24

=COUNTIF($A$1:$H$21,A24)

Then copy the formula down up to the 50th.

Regards,

Jon-jon
 
Hi

try
=countif($A$1:$H$21,A25)
where A1:H21 is the table containing the numbers and A25 contains the number
1
if A26 contains the number 2 , A27 the number 3 etc you could then fill this
formula down column B (from B25 onwards)

Cheers
JulieD
 
thank you very much


JulieD said:
Hi

try
=countif($A$1:$H$21,A25)
where A1:H21 is the table containing the numbers and A25 contains the number
1
if A26 contains the number 2 , A27 the number 3 etc you could then fill this
formula down column B (from B25 onwards)

Cheers
JulieD
Click to expand...
 
thank you very much


JON JON said:
Hello,

Suppose you start your number with A24 write this formula to B24

=COUNTIF($A$1:$H$21,A24)

Then copy the formula down up to the 50th.

Regards,

Jon-jon
Click to expand...
 
Back
Top