software

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-20One way:

0-40:

=COUNTIF(A:A,quot;lt;=40quot;) - COUNTIF(A:A, quot;lt;0quot;)

41-80:

=COUNTIF(A:A,quot;lt;=80quot;) - COUNTIF(A:A, quot;lt;=40quot;)

Alternatively:

0-40:

=SUMPRODUCT(--(A1:A100lt;=40),--(A1:A100gt;=0))

41-80:

=SUMPRODUCT(--(A1:A100lt;=80),--(A1:A100gt;40))In article gt;,
quot;bimseunquot; gt; wrote:

gt; I hav got the following numbers:
gt; A
gt; 45
gt; 54
gt; 12
gt; 32
gt; 55
gt; 78
gt; 65
gt; 45
gt; I want to use the count how many of this is within the ranges
gt; 0-40
gt; 41-80
gt; Please can someone advice on how to wtrite the function.
gt; bimseun
gt; 11-20


If your numbers are all greater than or equal to zero and in range
A1:A10

=COUNTIF(A1:A10,quot;lt;=40quot;)

If the above formula is in B1 then for 41-80

=COUNTIF(A1:A10,quot;lt;=80quot;)-B1--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=504465On Tue, 24 Jan 2006 06:13:02 -0800, quot;bimseunquot;
gt; wrote:

gt;I hav got the following numbers:
gt;A
gt;45
gt;54
gt;12
gt;32
gt;55
gt;78
gt;65
gt;45
gt;I want to use the count how many of this is within the ranges
gt;0-40
gt;41-80
gt;Please can someone advice on how to wtrite the function.
gt;bimseun
gt;11-20=COUNTIF(rng,quot;gt;=0quot;) - COUNTIF(rng,quot;gt;40quot;)

However, depending on your application, you might be better served using the
FREQUENCY worksheet function.
--ron