Summary function

[Guest]

When I summarize by every change in column A and sum the other columns it
works. But I to have the data in Column B as well. It just populates a '0'
because I am summing the totals of Columns C - D. I don't want to sum Column
B I just want the data to be brought down to the summary totals.

 

[Debra Dalgleish]

Instead of using subtotals, you could create a pivot table to summarize
the data. There are examples and links here:

http://www.contextures.com/xlPivot01.html

In the pivot table layout, put the fields from columns A and B into the
Row area, and put C and D into the Data area.