Countif Using Multiple Logic Tests

C

Carl

I am trying to use countif to count the number of times a number greater than
3 AND less than 10 occurs in a table. I can use countif for one criteria only
but cannot find a way to get it to work with more than one logic test. The
following formula does not work: COUNTIF(A1:A8,"and(>3,<10)")
Thanks in advance,
 
P

Peo Sjoblom

Use 2

=COUNTIF(A1:A8,">3")-COUNTIF(A1:A8,">=10")

or sumproduct

=SUMPRODUCT(--(A1:A8>3),--(A1:A8<10))

will return the same result

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
R

Ron Coderre

Try something like this:

=SUMPRODUCT((A1:A8>3)*(A1:A8<10))

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
C

Carl

That solved the problem. Thanks!

Peo Sjoblom said:
Use 2

=COUNTIF(A1:A8,">3")-COUNTIF(A1:A8,">=10")

or sumproduct

=SUMPRODUCT(--(A1:A8>3),--(A1:A8<10))

will return the same result

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
Click to expand...
 
Top