Thread: Percentages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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%