Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to calulate percent of total in column
Hello-
A5:A14 contain number values, and A15 is the total of these numbers. In column B, I need to figure the percent of total for the numbers in column A. For this example, B5 would = A5/A15, B6 would = A6/A15, etc, etc. The amount of rows in column A will change each time I run the report so I need the code to start in B5 and fill down to the next to last value in column as (since the last value is the total of column A). Any help will be appreciated. Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percent of times a value is in a column and total # | Excel Worksheet Functions | |||
I am trying to calulate total time | Excel Worksheet Functions | |||
code for adding a '% of total' column | Excel Programming | |||
Help required to code a '% of total' column | Excel Programming | |||
VB code to total up a column as the value change on another | Excel Programming |