I'm blogging about programming, but ... hey look over there - it's something shiny!
Wednesday, July 15, 2009
Excel: Counting The Occurance Of Values in a Range
Today I had an interesting Excel challenge. I needed to know for a column of numbers how many fall into a particular range. For example, how many numbers in column A are between 0.1 and 0.2? This is the formula I used from info at contextures.com: