=countif(range,"=6")-countif(range,"<12")

this formula doesn't work. It give you a wrong value



"Ashish Mathur" wrote:

Hi,

You could try either of the following:

=sumproduct((range=6)*(range<12)); or

=countif(range,"=6")-countif(range,"<12")

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Teeny" wrote in message
...
I need to find how many values in a column are greater than and including
6
but less than 12, I have tried many variations on COUNTIF and the numbers
just dont look right.

Can anyone help?