Re: Countif for a range of values

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Reggie (anonymous_at_discussions.microsoft.com)
Date: 09/17/04

Next message: Andy Brown: "Re: How to use the value of a cell in its displayed format?"
Previous message: Peter Atherton: "Edtae functions"
In reply to: JE McGimpsey: "Re: Countif for a range of values"
Next in thread: Reggie: "Re: Countif for a range of values"
Messages sorted by: [ date ] [ thread ]

Date: Fri, 17 Sep 2004 07:58:25 -0700

Hey - even better!

Thanks!

Reg
>-----Original Message-----
>Or, just a slightly shorter variation:
>
> =COUNTIF(A1:A10,">=6") - COUNTIF(A1:A10,">12")
>
>alternatively:
>
> =SUMPRODUCT(--(A1:A10>=6),--(A1:A10<=12))
>
>see
>
> http://www.mcgimpsey.com/excel/doubleneg.html for
the usage of --
>
>
>In article <O1fltFLnEHA.648@tk2msftngp13.phx.gbl>,
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote:
>
>> how about
>> =COUNTIF(A1:A10,">=" & 6)-COUNTIF(A1:A10,">"& 12)
>.
>

Next message: Andy Brown: "Re: How to use the value of a cell in its displayed format?"
Previous message: Peter Atherton: "Edtae functions"
In reply to: JE McGimpsey: "Re: Countif for a range of values"
Next in thread: Reggie: "Re: Countif for a range of values"
Messages sorted by: [ date ] [ thread ]