Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages of subtotals
I have a clolumn of figures with totals or subtotas at various places in the
column. I want to place a second column that shows the percentage of the first column of the subtotals. The subtotals are not necessarily equally spaced. I'd like to do an equation for the second column that can identify the subtotals so I don't have to go in and identify the specific reference for each subtotal. I'm thinking there ought to be a way to do this with a vlookup or if statement, but I seem to have my dumb hat on today. Any suggestion? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
percentages of subtotals
Hi
If you had a layout with the word Total or Subtotal appearing in Column A, and the values in column B and the Grand total in B30 then enter in C2 =IF(ISNUMBER(FIND("total",A2)),B2/$B$30,"") and copy down Amend to suit. -- Regards Roger Govier "Miaplacidus" wrote in message ... I have a clolumn of figures with totals or subtotas at various places in the column. I want to place a second column that shows the percentage of the first column of the subtotals. The subtotals are not necessarily equally spaced. I'd like to do an equation for the second column that can identify the subtotals so I don't have to go in and identify the specific reference for each subtotal. I'm thinking there ought to be a way to do this with a vlookup or if statement, but I seem to have my dumb hat on today. Any suggestion? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
Calculating percentages in pivot tables on subtotals | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |