Thread
:
frequency function with decimals
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
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???????????????
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko