Countif ?

W

Walker

I will try to make this as short as possible! Here is the situation.
need to count "incidences" based on particular criteria in a spreadshee
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
particular vaule falls between -2.5 and 2.5. Moving out in eithe
directions, I wish to count the number of incidences in increments of
in order fo populate a table with associated counts for each of th
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 te
nember of times a cell in a range falls within +/- 2.5 of the followin
midpoints: -100+/-95/-90/-85...0...5/10/15...100+

Thanks
 
A

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
 
Top