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???????????????

frequency function with decimals
 

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
wrote in message
...
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???????????????

frequency function with decimals
 

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


"frequency function with decimals" wrote:

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???????????????