Subtotals

Posted by Larry on August 04, 2000 2:13 PM

I have a very large parts list that includes order quantities, part number, description, etc. When I subtotal based on the part number, with the quantities summed, it all works well but the description cells are blank. I really need to see both part number and description togerther on the subtotal line along with the subtotaled quantity. Is there any way of doing this?

Posted by geo on August 04, 0100 2:40 PM

Try creating an extra column and using the following formula:

=@concatenate(a1,b1). a1 and b1 are the cells of the part number
and description, respectively. (You can use =@concatenate(a1,"-", b1)
to put a dash between the two)

then copy down to all of the other cells.

Then subtotal based on this new column.

Hope it works.