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:

=COUNTIF($A2:$A642,">" & L1) - COUNTIF($A2:$A642,">" & L2)

Where A2:A642 is my range of numbers and L1 is the lower bound of the range and L2 is the upper range.

No comments: