Excel to COUNTIF if number greater than one but less than another

R

Rooster8

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
 
K

Ken Wright

=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 :)
------------------------------­------------------------------­----------------
 
B

Bob Phillips

=COUNT(J2:J320) -COUNTIF(J2:J320,"<=3")-COUNTIF(J2:J320,">7")


--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return multiple values when within range (greater than and less than) 11
Greater Less or Equal 3
COUNTIF greater than one column and less than another 5
Problem with formula for finding last greater than/less than or equal to value 2
Excel Countif Function - Calculating Between Two Sets of Values 3
SMALL function to find X smallest number greater than Y 6
COUNTIF....how to use >=0 but <9 as CRITERIA 3
Countif, IF condition is met 2

Top