Countif ?

[Walker]

I will try to make this as short as possible! Here is the situation. I need to count "incidences" based on particular criteria in a spreadsheet that contains up to 50,000 rows in order to creat a series for graphing.

Starting in the middle, I wish to count the number of times a particular vaule falls between -2.5 and 2.5. Moving out in either directions, I wish to count the number of incidences in increments of 5 in order fo populate a table with associated counts for each of the following:
<-102.5
Between -97.5 and -102.5 (>-102.5 AND <-97.5)
Between -92.5 and -97.5 (>-97.5 AND <-92.5)
Between etc

to the positive end of the range. Essentially I need counts of teh nember of times a cell in a range falls within +/- 2.5 of the following midpoints: -100+/-95/-90/-85...0...5/10/15...100+

Thanks!

[Alok]

Use Histogram tool available under Tools/Data Analysis. For this you need to
have the following AddIn installed.

Analysis Toolpak

So if you do not see that option, first go to AddIns and check the Analysis
Toolpak addin and then you should be able to see the option.

Alok

"Walker" wrote:

>
> I will try to make this as short as possible! Here is the situation. I
> need to count "incidences" based on particular criteria in a spreadsheet
> that contains up to 50,000 rows in order to creat a series for graphing.
>
>
> Starting in the middle, I wish to count the number of times a
> particular vaule falls between -2.5 and 2.5. Moving out in either
> directions, I wish to count the number of incidences in increments of 5
> in order fo populate a table with associated counts for each of the
> following:
> <-102.5
> Between -97.5 and -102.5 (>-102.5 AND <-97.5)
> Between -92.5 and -97.5 (>-97.5 AND <-92.5)
> Between etc
>
> to the positive end of the range. Essentially I need counts of teh
> nember of times a cell in a range falls within +/- 2.5 of the following
> midpoints: -100+/-95/-90/-85...0...5/10/15...100+
>
> Thanks!
>
>
> --
> Walker
> ------------------------------------------------------------------------
> Walker's Profile: http://www.excelforum.com/member.php...o&userid=28037
> View this thread: http://www.excelforum.com/showthread...hreadid=475454
>
>

[Walker]

Thanks very much!!!