Re: counting functions

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

From: Soz (r_soz_at_bellsouth.net)
Date: 02/18/05


Date: Fri, 18 Feb 2005 07:26:08 -0500

Thanks Biff,
That works just the way I needed it to. The formula makes sense, but what is
the purpose of the two -- in the formula.
Thanks,
Soz

"Biff" <biffinpitt@comcast.net> wrote in message
news:028a01c5156c$966ec420$a501280a@phx.gbl...
> Hi!
>
> Assume the list is in column A:
>
> =SUMPRODUCT(--(A1:A20>=0),--(A1:A20<=3))
>
> Or, put the number ranges in two cells:
>
> B1 = 0
> C1 = 3
>
> =SUMPRODUCT(--(A1:A20>=B1),--(A1:A20<=C1))
>
> Biff
>
>>-----Original Message-----
>>Hi,
>>I have a long column list of numbers that I need to count
> instances of.
>>example: the instances of numbers >=0 & <=3, >=4 & <=7,
> etc.
>>Thanks,
>>Soz
>>
>>
>>.
>>



Relevant Pages

  • How do i sum vales of sales falling between certain time periods
    ... use cells to hold your date ranges: ... Biff ... >How do i have a summary table that shows only total sales ...
    (microsoft.public.excel.worksheet.functions)
  • Re: loading huge number of rules in iptables (blocklist)
    ... but what exactly is the purpose here? ... block/drop traffic from all the ip ranges listed in blocklist provided ... automate the process in iptables firewall on a router -- needs iptables, ... a little scripting could probably concatenate a lot of the ...
    (Debian-User)
  • Re: Data Validation
    ... I do not believe I have mis-understood the purpose of 'ignore blanks', ... If the source list is a named range that contains blank cells, ... I don't know why your users are allowed to enter a EUR unless you ...
    (microsoft.public.excel)
  • Re: Human design and natural "design"
    ... > I always keep coming back to the metaphor of cells in a ... Most people would not consider individual cells as ... > "purpose" dictated by an organ (functioning well for the ... > intentionality," i.e., not intentionality at all as we know ...
    (sci.bio.evolution)
  • Re: Looking for control to define an ordered group of numerical ranges
    ... > of items in that window, ... > each of these ranges would also be needed. ... You could also use some vertical movable markers for tis purpose. ... are available in my Rt-Tools2D components: ...
    (borland.public.delphi.thirdpartytools.general)