| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel to COUNTIF if number greater than one but less than another
I'm using COUNTIF for a column of 320 numbers that range from 1 to 35. I am
trying to have 3 running totals. I'm having difficulty with the middle equation. The first 2 seem to be working - 1. The number of instances where the entry is less than or equal to 3. =COUNTIF(J2:J320,"<=3") 2. The number of instances where the entry is greater than 7. =COUNTIF(J2:J320,"7") I can't figure out the equation for greater than 3 but less than or equal to 7. Thanks, R |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
| Excel countif function | Excel Worksheet Functions | |||
| how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
