I am attempting to create a report in an Excel spreadsheet using Excel’s subtotals feature. At each section break, I need to sum Column 1, sum Column 2, and then in Column 3 I would like to get the percentage: (Column 1 subtotal / Column 2 subtotal) x 100. The number of rows within each subtotaled section is not constant.
If anyone can provide any (non-VBA) assistance, it would be much appreciated!
Bookmarks