Summary function davies 13.07.2006 13:42:02 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.

Re: Summary function Debra Dalgleish <dsd[ at ]contexturesXSPAM.com> 14.07.2006 17:09:31 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. davies wrote: [Quoted Text] > 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 Contextures http://www.contextures.com/tiptech.html