frequency function with decimals

[frequency function with decimals]

I have a set of 365 different numbers and some of the numbers are decimals
(i.e.: 921.74). How do I use the frequency function to determine how many
numbers in my set fall into certain categories that I want to create. For
example, if I want my category to include all the numbers in my set greater
than but not equal to 110 and less than but not equal to 230 and some of the
numbers in my set are decimals how do I do this???????????????

 

[T. Valko]

One way:

=COUNTIF(A1:A365,">110")-COUNTIF(A1:A365,">=230")

Or, using cells to hold the boundaries:

C1 = 110
D1 = 230

=COUNTIF(A1:A365,">"&C1)-COUNTIF(A1:A365,">="&D1)


--
Biff
Microsoft Excel MVP


"frequency function with decimals" <frequency function with
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Teethless mama]

=SUM(COUNTIF(A1:A365,{">110",">=230"})*{1,-1})