COUNTIF for range of numbers

Posted to microsoft.public.excel.misc

bimseun

Posts: n/a

COUNTIF for range of numbers

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Checking Winning Numbers in the Lottery.	Ann	Excel Discussion (Misc queries)	4	May 18th 05 10:55 AM
Using COUNTIF to find numbers within a range greater than the mean	Lowkey	Excel Worksheet Functions	2	May 17th 05 06:34 PM
How can I change positive numbers to negative, i.e. change 50 to -	godwingi	Excel Discussion (Misc queries)	5	February 28th 05 05:41 PM
Sorting when some numbers have a text suffix	confused on the tundra	Excel Discussion (Misc queries)	5	December 18th 04 10:19 PM
GET NON-ZERO RESULTS USING STDEV FOR CERTAIN NUMBERS	Non-zero return for Stdev	Excel Worksheet Functions	2	December 16th 04 08:44 AM

All times are GMT +1. The time now is 09:12 PM.

Menu

About Us