Summing SUBTOTAL math function

[Laura Alessi]

Hi,

I am working on a file where I have a long list of trips with subtotals in between for example:

REASON 1
TRIP 1: 2
TRIP 2: 3
TRIP 3: 4
TOTAL REASON 1: 9

REASON 2
TRIP 1: 1
TRIP 2: 3
TRIP 3: 4
TOTAL REASON 2: 8

I have over 100 of these "reasons" and I want to be able add all of the totals without going through and indvidually clicking on each cell. Right now the formula I am using to get the individual reasons total is SUBTOTAL(9,insert range). I cannot change the format of the sheet (can't add lists etc.) but I can change the subtotal formula to something else. Is there any formula in Excel that I can use to add all of the cells that use the SUBTOTAL function?

Please help... I feel like there has to be a way to do this and I can't figure it out.

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorial...b-7374d3da3425/wpf-and-the-model-view-vi.aspx

 

[Gord Dibben]

Data>Subtotals should work.

If not, simply sum the entire column including totals then divide by two.

=SUM(B:B)/2


Gord Dibben MS Excel MVP

 

[Dave Peterson]

You can use =subtotal() once more.

The =subtotal() function will ignore other =subtotal() functions in that range.