Use COUNTIF():

=COUNTIF(A1:A10,"3")-COUNTIF(A1:A10,"7")

will count the number of cells with value greater than 3 and less than 7

--
Gary's Student


"woogiebooboo" wrote:

I know this is going to be an easy answer nut I just cant figure it out...
How do I count a cell that is greater than a specific and less than a
another specific number....or to count it if it contains a number in a
specific range?