Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??????????????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??????????????? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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??????????????? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency Function | Excel Worksheet Functions | |||
Function to ignore decimals | Excel Worksheet Functions | |||
a function on decimals | Excel Worksheet Functions | |||
Frequency function | Excel Discussion (Misc queries) | |||
Using FREQUENCY Function to Count | Excel Worksheet Functions |