percentages of subtotals

[Guest]

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?

 

[Roger Govier]

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.