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 |
#2
|
|||
|
|||
Excel to COUNTIF if number greater than one but less than another
=COUNTIF(J2:J320,"3")-COUNTIF(J2:J320,"7")
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Rooster8" wrote in message ... 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 |
#3
|
|||
|
|||
Excel to COUNTIF if number greater than one but less than another
=COUNT(J2:J320) -COUNTIF(J2:J320,"<=3")-COUNTIF(J2:J320,"7")
-- HTH RP (remove nothere from the email address if mailing direct) "Rooster8" wrote in message ... 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 |
Reply |
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) |