
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 subtotal towards the bottom of
the page, the other two demonstrate how to subtotal towards the top of the
page.



The formulas use one or some of the following
functions:



Purpose 
Formula to subtotal analysis at random positions 


Download 
subtotals.zip 



