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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com