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?