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?
Formula in I2:
=SUMPRODUCT(--(ROUNDDOWN(G2,2)=ROUNDDOWN($G$2:$G$11,2))) + ENTER
Functions in this article:
Rounds a number down to zero.
SUMPRODUCT(array1, array2, )
Returns the sum of the products of the corresponding ranges or arrays