| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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% |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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% |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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% |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Frogs in the pond - Display percentages not numbers | Charts and Charting in Excel | |||
| Frogs in the pond - percentages not numbers | Charts and Charting in Excel | |||
| stacked bar chart with percentages | Charts and Charting in Excel | |||
| Rounding percentages problem need a solution for | Excel Discussion (Misc queries) | |||
| What format do I use to mail merge percentages? | Excel Discussion (Misc queries) | |||
Linear Mode
