counting problem

[jrussell]

I have a series of numbers in cell B1 thru B26. Is there a way to count the numbers in this range that are >1 and <11 and have this number show up in cell B27?
The count if function will only work with one criteria.
Any suggestions?

Thanks in advance.

Jerry

 

[Dave Patton]

With criteria in D1 and D2

=COUNTIF(B1:B26,">"&D1)-COUNTIF(B1:B26,">"&D2)

 

[Yogi Anand]

On 2002-04-15 20:16, Dave Patton wrote:


With criteria in D1 and D2

=COUNTIF(B1:B26,">"&D1)-COUNTIF(B1:B26,">"&D2)

Hi Dave: Looks Good!
And to go a step further

=COUNTIF(B1:B26,E1)-COUNTIF(B1:B26,E2)

if E1 contained the criterion ...<11
and E2 contained ...<=1

_________________
Yogi Anand
Edit: Deleted reference to inactive web site from signature line
This message was edited by Yogi Anand on 2003-01-19 18:24