Using a CountIf formula, how do I count the number of cells in a range of
cells that have a value greater than and less than two specified number, i.e.
0=x<=17?

"Clinic Reporter" <Clinic wrote in
message ...
Using a CountIf formula, how do I count the number of cells in a range of
cells that have a value greater than and less than two specified number,
i.e.
0=x<=17?

You can use 2 COUNTIFs for a process of elimination:

=COUNTIF(A:A,"<17")-COUNTIF(A:A,"<=0")

HTH,
Andy