| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Number of items meeting a > criterion
Is there a way to count the number of cells with numbers greater than X in a
column? I'd appreciate the help. |
|
#2
|
|||
|
|||
|
Mike -
Assume your data is in the range A1:A100 and you want to count how many numbers are greater than 10, this formula will work: =COUNTIF(A1:A100,""&10) -- David Billigmeier "MikeDH" wrote: Is there a way to count the number of cells with numbers greater than X in a column? I'd appreciate the help. |
|
#3
|
|||
|
|||
|
Excellent. Thank you much sir.
"David Billigmeier" wrote: Mike - Assume your data is in the range A1:A100 and you want to count how many numbers are greater than 10, this formula will work: =COUNTIF(A1:A100,""&10) -- David Billigmeier "MikeDH" wrote: Is there a way to count the number of cells with numbers greater than X in a column? I'd appreciate the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| count number of items in a row? help *file included* | Excel Worksheet Functions | |||
| Maximum number of rows? | Excel Discussion (Misc queries) | |||
| Is the data validation criteria limited to a few number of items . | Excel Worksheet Functions | |||
| Convert week number into calendar month? | Excel Worksheet Functions | |||
Linear Mode
