Use a number range when trying to find the frequency of a number in excel
Filed in Excel on May.25, 2010. Email This article to a Friend
Question:
Is there a way I can use a data range when trying to find the frequency of a number?
The number ranges are:
larger or equal to 21% and smaller than 22%,
larger or equal to 22% and smaller than 23% and so forth.
Example, 21,24% is larger or equal to 21% and smaller than 22%.
How to calculate how often values (G2:G11) occur within each number range?
Answer:
Formula in I2:
=SUMPRODUCT(--(ROUNDDOWN(G2,2)=ROUNDDOWN($G$2:$G$11,2))) + ENTER
Functions in this article:
ROUNDDOWN(number, num_digits)
Rounds a number down to zero.
SUMPRODUCT(array1, array2, )
Returns the sum of the products of the corresponding ranges or arrays








Leave a Reply