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%
|