Re: Countif for a range of values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 ]

Relevant Pages

.PATH-problem [was Re: make or kmod.mk broken]
... is to support easy building of firmware modules. ... # Script to generate module .c file from a list of firmware images # function usage { ... exit 1;} # These are just for convenience ... ...
(freebsd-current)
Re: Hey for hi
... each other with "Hey", ... The growth in usage of "hey" was, I think, a gradual one taking place over ... or at any rate there are rural antecedents. ...
(alt.usage.english)
Re: Hey for hi
... big growth in usage took place during the 1980s rather than ... have your attention" usage. ... Hey, Jude, how's it going? ...
(alt.usage.english)
Re: Hey for hi
... have your attention" usage. ... Hey, Jude, how's it going? ... "It has come to my attention that my opinions are not universally ...
(alt.usage.english)
Re: My jury story
... Reg writes: ... Hey, they are both civic duties. ... And if you shirk, someone else is ...
(rec.food.cooking)