=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.
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:
Where A2:A642 is my range of numbers and L1 is the lower bound of the range and L2 is the upper range.
Where A2:A642 is my range of numbers and L1 is the lower bound of the range and L2 is the upper range.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment