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?

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?