Percentages

[Guest]

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

11, 10, 122, 96

Numbers >120 = 25%

 

[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(A11,"<="&120) - COUNTIF(A11,"<"&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

 

[Guest]

How do I calculate what percentage is beween a range?

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

Thanks

 

[Guest]

Got it, thanks for your help.

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