| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Count if number between two numbers in Excel?
I am trying to count how many times a number =94 and <95 occurs in a column?
I can get it to count how many above a number or below but not in between. |
|
#2
|
|||
|
|||
|
one way:
=COUNTIF(A:A,"=94") - COUNTIF(A:A,"=95") another: =SUMPRODUCT(--(INT(A1:A1000)=94)) In article , "Kblue74" wrote: I am trying to count how many times a number =94 and <95 occurs in a column? I can get it to count how many above a number or below but not in between. |
|
#3
|
|||
|
|||
|
The countif function worked as needed. Thank you. "Kblue74" wrote: I am trying to count how many times a number =94 and <95 occurs in a column? I can get it to count how many above a number or below but not in between. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| Count and Sum Total occurrances of two specific numbers | Excel Worksheet Functions | |||
| Excel: Which numbers in a column equal a certain number (withou. | Excel Worksheet Functions | |||
| count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
