Insert number of rows based on cell values?

Column B contains geographical Areas. Column C contains a list of business departments.

North Env
North Env
North Ops
North Sales
North Sales
North Sales
South Env
South Maint
South Ops
South Sales
South Sales
South Sales

Etc.

The values and number of these departments will vary.

I want to insert lines to sum the totals at the bottom of each geographic area based on the number of different departments. So, for this example, for the North three lines would be inserted. For the South, 4 lines would be inserted.

Any ideas?

Not exactly clear to me what the result is meant to look like but you could perhaps check out XL's in built Subtotal functionality ?

For ex. you also don't specify where the values are you wish to Sum... let's assume Col D...

Highlight your data in B:D (you should have headers in the first row) then -> Data -> Insert Subtotals

Set up such that at Each Change in Col C insert a SUM into Col D

Is that what you want ?

Sort of, there are many different values in column C, so going back through the spreadsheet and adding subtotals would be very time consuming.

In my example, I am aiming for a row to be inserted after North Env with a sum in col R through col IT of the data in North Env row 1 (R through IT) and North Env row 2 (R through IT).

So it would look like:
North Env
North Env
North Env Total
North Ops
North Ops Total
North Sales
North Sales
North Sales
North Sales Total


You said "Set up such that at Each Change in Col C insert a SUM into Col D".
If there is a way to automate the subtotal function, that would be most helpful.

It is an entirely automated feature - follow the steps outlined.

see here for an actual screenshot: http://pubs.logicalexpressions.com/P...cle.asp?ID=358

Finally got it - Thanks for your help.