[DerekM]

The summary option for columns works such that every parent row is a summary of it's children. If you have data manually entered into a parent row, it will get erased when you pick a summary type. Summary cells are indicated by the gray background fill.

It sounds like you will need to reorganize your document or change where you're placing the paid data so you can use the summary option. Go ahead and send me a sample doc if you're still having trouble with it.