Re: counting functions
From: Soz (r_soz_at_bellsouth.net)
Date: 02/18/05
- Next message: Jim May: "Re: Sumif() with criteria"
- Previous message: Jason Morin: "Re: check occurrence of items in a range"
- In reply to: Biff: "counting functions"
- Next in thread: Biff: "Re: counting functions"
- Reply: Biff: "Re: counting functions"
- Reply: RagDyeR: "Re: counting functions"
- Messages sorted by: [ date ] [ thread ]
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
>>
>>
>>.
>>
- Next message: Jim May: "Re: Sumif() with criteria"
- Previous message: Jason Morin: "Re: check occurrence of items in a range"
- In reply to: Biff: "counting functions"
- Next in thread: Biff: "Re: counting functions"
- Reply: Biff: "Re: counting functions"
- Reply: RagDyeR: "Re: counting functions"
- Messages sorted by: [ date ] [ thread ]
