Percentages
 

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

11, 10, 122, 96

Numbers 120 = 25%

Percentages
 

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

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

11, 10, 122, 96

Numbers 120 = 25%

Percentages
 

How do I calculate what percentage is beween a range?

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

Thanks

"Pete_UK" wrote:

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

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

11, 10, 122, 96

Numbers 120 = 25%

Percentages
 

Got it, thanks for your help.

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

"Rex" wrote:

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

11, 10, 122, 96

Numbers 120 = 25%