Countif ?
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 |
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 |
Thanks very much!!! -- Walker ------------------------------------------------------------------------ Walker's Profile: http://www.excelforum.com/member.php...o&userid=28037 View this thread: http://www.excelforum.com/showthread...hreadid=475454 |
All times are GMT +1. The time now is 04:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com