Countif Between

[Alex]

I need to count how many cells in column D have a value in them between 7 and
3.
I cant find anything that lets me use between as criteria and Countif only
allows me to have 1 criteria.

Any ideas?

 

[Jason Morin]

Here are 3 possible ways (inclusive):

=COUNTIF(D1100,">=3")-COUNTIF(D1100,">7")
=SUMPRODUCT(--(D1100>=3),--(D1100<=7))
=COUNT(D1100)-SUM(COUNTIF(D1100,{"<3",">7"}))

HTH
Jason
Atlanta, GA

 

[JulieD]

Hi Alex

here's two methods
=SUMPRODUCT(--(D335>3),--(D335<7))
=COUNTIF(D335,">"&3)-COUNTIF(D335,">"&6)

Cheers
JulieD