Carrie I have almost the exact same situaton. Were you able to figure it out
using a Pivot Table? If so, please let me kno whow. I know the subtotaling
thing will work, but I have a massive spreadsheet with about 30 columns & a
pivot table would be so much easier to read.

"Carrie" wrote:

I would like to know if there is a way to to merge lines in excel, sum a
number, then do the same for the next person-- for instance:

ID name start end salary
1235 John doe 1/1/05 1/31/05 100
1235 john doe 2/1/28 2/28/05 200

(summary) 1235 john doe 1/1/05 2/28/05 300