| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating data between two given parameters
If i have a range of A1:A300 and the range of numbers within those cells
could be anything from 1 to 50 how do i count cells that contain numbers greater than 20 but less than 31? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating data between two given parameters
=COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"30")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Craig" wrote in message ... If i have a range of A1:A300 and the range of numbers within those cells could be anything from 1 to 50 how do i count cells that contain numbers greater than 20 but less than 31? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating data between two given parameters
Unless the numbers are contrained to being integers, it may be preferable to
use =COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"=31") -- David Biddulph "Bob Phillips" wrote in message ... =COUNTIF(A1:A300,"20")-COUNTIF(A1:A300,"30") "Craig" wrote in message ... If i have a range of A1:A300 and the range of numbers within those cells could be anything from 1 to 50 how do i count cells that contain numbers greater than 20 but less than 31? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External data using parameters through to excel | Excel Discussion (Misc queries) | |||
| Calculating p-value from Fisher's Exact Test for XYZ parameters | Excel Worksheet Functions | |||
| can custom autofilter pull parameters from other data? | Excel Discussion (Misc queries) | |||
| How to summarize data based on specific parameters | Excel Discussion (Misc queries) | |||
| parameters option on the external data toolbar is not available | Excel Discussion (Misc queries) | |||
Linear Mode
