Prev: Get data - Multiple criteria
Next: How to write a macro to hide an entire row
From: Bill on 14 Apr 2010 03:23
Have a column of figures and want to countif the value in cell falls between
x or y
That is countif(e:e, >5 or <10)
From: Jacob Skaria on 14 Apr 2010 03:36
Hi Bill

Try

=COUNTIF(A:A,">5")-COUNTIF(A:A,">=10")

OR

=SUMPRODUCT((A1:A100>5)*(A1:A100<10))


--
Jacob (MVP - Excel)


"Bill" wrote:

> Have a column of figures and want to countif the value in cell falls between
> x or y
> That is countif(e:e, >5 or <10)
 | 
Pages: 1
Prev: Get data - Multiple criteria
Next: How to write a macro to hide an entire row