Re: COUNTIF for range of numbers
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Tue, 24 Jan 2006 09:40:33 -0500
On Tue, 24 Jan 2006 06:13:02 -0800, "bimseun"
<bimseun@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I hav got the following numbers:
>A
>45
>54
>12
>32
>55
>78
>65
>45
>I want to use the count how many of this is within the ranges
>0-40
>41-80
>Please can someone advice on how to wtrite the function.
>bimseun
>11-20
=COUNTIF(rng,">=0") - COUNTIF(rng,">40")
However, depending on your application, you might be better served using the
FREQUENCY work*** function.
--ron
.
- Prev by Date: Re: Removing characters from a cell (keeping only numbers) 2
- Next by Date: Re: double click a cell with Date format
- Previous by thread: Re: COUNTIF for range of numbers
- Next by thread: Re: How do I add verbiage to a cell that has a hyperlink already
- Index(es):
