Posted to microsoft.public.excel.worksheet.functions

David G[_2_] David G[_2_] is offline

external usenet poster

Posts: 9

multiple data ranges for countif

I am trying to find the number of times my value falls in a certain range.
the data looks like this:
Clg (Tons)
500.6
486.9
473.4
465.8
469.8
510.1
497.5
538.9
623.5
688.5
671.8
687.3
673.9
690.9
716.5
713.7
704.6
665.8
606.3
599.9
582.3
497.4
498.8
478.8

and my different ranges would be in one hundred increments (i.e. 400-500,
501-600,601-700,etc.)
Any help would be great

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
countif for multiple ranges and criteria	MML	Excel Discussion (Misc queries)	7	May 25th 07 09:54 PM
Using Multiple, Noncontiguous Ranges in COUNTIF?	PBJ	Excel Discussion (Misc queries)	0	October 11th 06 05:45 PM
COUNTIF() With multiple ranges and variables	Thansal	Excel Discussion (Misc queries)	3	July 12th 06 05:32 PM
COUNTIF with multiple disjoint ranges, same criteria	CLR	New Users to Excel	0	March 3rd 06 08:00 PM
COUNTIF Statement with Multiple Conditions in Different Ranges	KJA	Excel Worksheet Functions	2	April 26th 05 05:14 PM

All times are GMT +1. The time now is 06:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us