values greater than and including

  • Thread starter Thread starter Teeny
  • Start date Start date
T

Teeny

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?
 
Hi

Both formulas will do it:

=SUMPRODUCT(--(A1:A10>=6),--(A1:A10<12))

=COUNTIF(A1:A10,">=6")-COUNTIF(A1:A10,">12")

Regards,
Per
 
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
 
=countif(range,">=6")-countif(range,"<12")

this formula doesn't work. It give you a wrong value
 
greater than and including 6 but less than 12
=COUNTIF(A1:A10,">=6")-COUNTIF(A1:A10,">12")
Click to expand...

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

Try it like this:

=COUNTIF(A1:A10,">=6")-COUNTIF(A1:A10,">=12")
 
Hi,

In 2007:
=COUNTIFS(A1:A15,">=6",A1:A15,"<12")

In 2003:
=SUMPRODUCT(--(A1:A15>=6),--(A1:A15<12))
 
Back
Top