Summary function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

davies - 13 Jul 2006 14:42 GMT

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.

Reply to this Message

Debra Dalgleish - 14 Jul 2006 18:09 GMT

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.

> 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.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Rate this thread: