software

I was given a file in outline form. It has summary rows which include the
quantity. How can I copy detail information to that summary row?

Example:

Let's say one of the groups is all a type of chair, and the detail rows are
same type of chair different color. So the quantity of each color would be
different, but the price is the same. The summary row has the total quantity
for that type of chair, but not the price. How can I put the price in the
summary row, so I can calculate total ?

Item, Quantity, Price
blue, 3, $50
red, 10, $50
green, 2, $50
Summary Chair, 15

Is there a function where I can have Excel put the $50 in the Summary row
automatically?
Try clearing the outline and using Data--gt;Subtotals.
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Hobbes2006quot; gt; wrote in message
...
gt;I was given a file in outline form. It has summary rows which include the
gt; quantity. How can I copy detail information to that summary row?
gt;
gt; Example:
gt;
gt; Let's say one of the groups is all a type of chair, and the detail rows
gt; are
gt; same type of chair different color. So the quantity of each color would be
gt; different, but the price is the same. The summary row has the total
gt; quantity
gt; for that type of chair, but not the price. How can I put the price in the
gt; summary row, so I can calculate total ?
gt;
gt; Item, Quantity, Price
gt; blue, 3, $50
gt; red, 10, $50
gt; green, 2, $50
gt; Summary Chair, 15
gt;
gt; Is there a function where I can have Excel put the $50 in the Summary row
gt; automatically?
gt;
gt;