| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentage of Multiple Rows
I'm trying to copy a formula.
The worksheet has 10 rows of numbers and I want to find what percentage of the total each row equals. As my starting formula, I've entered "=A1/A11" I then copy the formula and paste it into rows 2-10. But what I end up with are formulas reading "=A1/A12," "=A1/A13," "=A1/A14" and so on. How do I keep the dividing number constant? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating percentage-using rows | Excel Discussion (Misc queries) | |||
| raising multiple cells containing numbers by a percentage | Excel Discussion (Misc queries) | |||
| Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
| Changing multiple cells by the same percentage | New Users to Excel | |||
| Pivot table - Gross Profit Percentage subtotal with multiple items | New Users to Excel | |||
Threaded Mode
