| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how can i count a number that meets a criteria?
hi.
I have a column of numbers in a sheet. how can I count the numbers between 5 & 10 (for example) in the column? thanks. |
|
#2
|
|||
|
|||
|
oak
=COUNTIF(A1:A10,"5")-COUNTIF(A1:A10,"9") You sure you mean "between" 5 and 10 which would be 6,7,8 or 9? Gord Dibben Excel MVP On Thu, 10 Mar 2005 14:27:04 -0800, "oakm" wrote: hi. I have a column of numbers in a sheet. how can I count the numbers between 5 & 10 (for example) in the column? thanks. |
|
#3
|
|||
|
|||
|
Insert a Column
give a formula - if (And(a14,a1<11)," To Count","Not Count", You will get a result as To count or Not Count. Then Count all To Counts "oakm" wrote: hi. I have a column of numbers in a sheet. how can I count the numbers between 5 & 10 (for example) in the column? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
| How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count number to reach a cumulative value | Excel Worksheet Functions | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
