The Data Subtotals function will do this for you
automatically. It wont give you two lines between, but
will give you a department name and total $.

The alternative is to use a sub to go down the $ column,
determine if the current cell is blank, and if so insert a
subtotal formula.

Steve
-----Original Message-----
I have a spreadsheet that lists expenditures of different
departments.
Each department is separated from the next by two blank
rows and is of
various lengths from day to day. How can I subtotal the
expenditure
column of each dept so that the subtotal appears in the
first blank row
below that dept and then totals the whole column ( making
sure the
subtotals don't get added again)? Thanks for any help.
Gib


---
Message posted from http://www.ExcelForum.com/

.