Percentages

R

Rex

How do I calculate the percentage of numbers (A1:A4) that are >120
or >70 and <120?

11, 10, 122, 96

Numbers >120 = 25%
 
P

Pete_UK

Do you mean something like:

=COUNTIF(A1:A4,">"&120) / COUNT(A1:A4)

formatted as a percentage. If you want the number within a range, try
this:

=COUNTIF(A1:D1,"<="&120) - COUNTIF(A1:D1,"<"&70)

Essentially, count the number that are less than or equal to 120 and
subtract the number that are less than 70.

Hope this helps.

Pete
 
R

Rex

How do I calculate what percentage is beween a range?

=countif(a1:a4,">=100 and <=120") /count(a1:a4)

Thanks
 
R

Rex

Got it, thanks for your help.

=SUMPRODUCT(--(H1:H52>100),--(H1:H52<120))/COUNT(H1:H52)
 
Top