I have encountered a problem. A question I have is to show the total quantity sold of each book.

But the problem is for example my system I have created is an order form for cds so for example if I was to other a new cd called clubland. Then if I was to order that cd again labelled clubland how am I meant to get it to always add that quantity together for the item seen as the cd text called clubland is now on a newline.

Another problem is it can be done but the assignment has to have a screen where you can input another cd name so for example if you input another cd name you can't get excel to pick up the name of the new cd.