Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF a cell value is between two numbers
I have a range of cells (D$9:D350) and I want to count the number of
instances that a number in the cell range is between 100 and 400. I keep getting errors. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF a cell value is between two numbers
One way:
This also counts 100 and 400. =COUNTIF(D9:D350,"=100")-COUNTIF(D9:D350,"400") -- Biff Microsoft Excel MVP "LAWNDALE" wrote in message ... I have a range of cells (D$9:D350) and I want to count the number of instances that a number in the cell range is between 100 and 400. I keep getting errors. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF a cell value is between two numbers
Very helpful. Thanks.
"LAWNDALE" wrote: I have a range of cells (D$9:D350) and I want to count the number of instances that a number in the cell range is between 100 and 400. I keep getting errors. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF a cell value is between two numbers
You're welcome!
-- Biff Microsoft Excel MVP "LAWNDALE" wrote in message ... Very helpful. Thanks. "LAWNDALE" wrote: I have a range of cells (D$9:D350) and I want to count the number of instances that a number in the cell range is between 100 and 400. I keep getting errors. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif numbers fall between two values | Excel Worksheet Functions | |||
countif colored numbers | Excel Worksheet Functions | |||
COUNTIF for range of numbers | Excel Discussion (Misc queries) | |||
Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions | |||
Countif for numbers between x and y | Excel Worksheet Functions |