Outline Group Subtotal Function

[cr2289]

Help please! I have a lengthy spreadsheet that uses the subtotal function so there are total rows on the spreadsheet. I would like to insert a formula only to the total rows that will show the results of subtracting two of the subtotals. Help?

 

[SpillerBD]

Run a filter on the column that has the "Total" text in it. Text filter, Contains....
Than in the first cell, set up your formula and then copy/paste to the other rows enmasse.

 

[SpillerBD]

Alternative... Pivot Table does it better with calculated field.