Posted to microsoft.public.excel.programming

SSM

external usenet poster

Posts: 3

Counting instances of an incident happening

My worksheet is like this:
A1 A2...
120 210 333 400 510 625 789 801 ...10000

How can I get the how many of the cells the cells have a value between 0 and
400 (in the question above 4), how many times the cells have a value between
401 and 800 (3), etc.?

Thanks in advance...

Regards,
SSM

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
Counting Consecutive Instances	carl	Excel Worksheet Functions	3	September 24th 07 07:08 PM
Counting instances in string	John in Wembley	Excel Discussion (Misc queries)	11	September 18th 07 06:51 PM
Counting Multiple Instances	Curtis	Excel Worksheet Functions	3	January 31st 07 06:22 PM
Counting instances in a cell	[email protected]	Excel Discussion (Misc queries)	2	December 11th 04 03:14 PM
Counting Instances of a Value?	Neil[_17_]	Excel Programming	2	December 5th 03 08:36 PM

All times are GMT +1. The time now is 09:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us