Subtotals on random lines

 
Sometimes you need to subtotal on random lines in your analysis. This workbook demonstrates a formula based method to achieve this.
 
No VBA used
 
Here's one of the four examples in the demonstration workbook.

Two of the examples demonstrate how to sub-total towards the bottom of the page, the other two demonstrate how to sub-total towards the top of the page.

 

 
The formulas use one or some of the following functions:
  • IF
  • SUM
  • SUMIF
   
Purpose

Formula to subtotal analysis at random positions

 

Download

subtotals.zip