Attach is a sample worksheet. It has simple subtotals on it. But I dont want the subtotal to sum every column. For the cash% column, i want it to be the subtotal of the cash column divided by the subtotal of the credit column. For the tax% subtotal, I want it to be the subtotal of the tax column divded by the subtotal of the cash column.
Is there a macro for this? Like instead of the subtotal summing it, can it be divide?