Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
Looking for a formula that will allow me to count how many numbers in a range fall between larger than 50% and smaller than 85% as well as larger than 85% and less than 100%. Currrently I am using a countif(range,<.5) and countif(range.5) but if I want to expand my criteria to count how many are 85 and 100, the values for 100 are in with the values from 85 and subtracting them gives me a negative number. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
syntax for countif when cells fall within a numerical range | Excel Worksheet Functions | |||
Charting X values when they rise and fall | Charts and Charting in Excel | |||
how do i sum 2 values that fall between date ranges? | Excel Worksheet Functions | |||
making used values fall from a list | Excel Discussion (Misc queries) | |||
Need totals of values that fall within a given year | Excel Worksheet Functions |