oak

=COUNTIF(A1:A10,"5")-COUNTIF(A1:A10,"9")

You sure you mean "between" 5 and 10 which would be 6,7,8 or 9?


Gord Dibben Excel MVP

On Thu, 10 Mar 2005 14:27:04 -0800, "oakm"
wrote:

hi.
I have a column of numbers in a sheet.
how can I count the numbers between 5 & 10 (for example) in
the column?
thanks.