countif "between" criteria

D

Dave the Man

Is it possible to use a countif formula with a 'between' criteria, e.g
count all those that are between 7 and 14
 
F

firefytr

how about...

=countif(range,"<="&14)-countif(range,"<"&7)

some variation of this maybe?
 
R

Ragdyer

These will count items from 7 *to* 14, *including* 7 & 14:
=COUNTIF(A1:A20,"<=14")-COUNTIF(A1:A20,"<7")
=COUNTIF(A1:A20,">=7")-COUNTIF(A1:A20,">14")

These will count items *between* 7 & 14, *excluding* 7 & 14:
=COUNTIF(A1:A20,"<14")-COUNTIF(A1:A20,"<=7")
=COUNTIF(A1:A20,">7")-COUNTIF(A1:A20,">=14")
 

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

countifs Function not giving desired result with date criteria 2
Using <= in countifs statement 1
Countifs bites again 4
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Need countifs forumla to analize in a time range 2
Finding the weighted average of text that have been given values 1
COUNTIF multiple criteria 2

Top