Countif Between
 

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?

Here are 3 possible ways (inclusive):

=COUNTIF(D1:D100,"=3")-COUNTIF(D1:D100,"7")
=SUMPRODUCT(--(D1:D100=3),--(D1:D100<=7))
=COUNT(D1:D100)-SUM(COUNTIF(D1:D100,{"<3","7"}))

HTH
Jason
Atlanta, GA

-----Original Message-----
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?
.

Hi Alex

here's two methods
=SUMPRODUCT(--(D3:D353),--(D3:D35<7))
=COUNTIF(D3:D35,""&3)-COUNTIF(D3:D35,""&6)

Cheers
JulieD

"Alex" wrote in message
...
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?