Help Please

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

Hi,

In column S i have numbers i.e.
1
2
5
8
12
102
Etc!
How can i count how many times the numbers 1 to 7, or 8 to 15 etc! occur.

Regards,

Eamon
 
since they are integers:
=countif(A:A,">=1")-countif(A:A,">7")

=countif(A:A,">=8")-countif(A:A,">15")
 
Eamonn,

You could also use the FREQUENCY function.

Create a range with the upper bounds of each group (7,15,22 etc in C1:C5
say), select a number of cells equal to the number of boundary points, enter
the formula =FREQUENCY(A1:A100,C1:C5) as an array formula, that is commit
with Ctrl-Shift-Enter not just Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Frank, Tom & Bob,

Thanks to you all for your help, very much appreciated.

Best regards

Eamon
 
Back
Top