Hello,
Using Excel 2003, what is the formula I would use to accomodate the
automatic calculation of multiple percents within the same worksheet?

For example, if I needed to know what both 6% and also 9% as below?

Subtotal % of Subtotal Total added to %
of Subtotal
10 + 25 = 35 6% 37.1
15 + 26 = 41 15% 47.15

Thanks,
Paula