hello, i'm new here and i want some help from you guys. hope you'll help me
with this..

i want to create program in excel just like inventory of item sales. example

product Name ------------------ name of product
quantity:____ ----------------- quantity of the item sold will be input
here (i.e. 1)

total amount:_____------------------- number inputted in quantity will
multiply by the fix retail price of prodcuct will be shown here.

I want to make a program like this---- after the amount is shown in the
Total amount Cell, I want the cell in a quantity where I input a number will
be reset to zero so I can input another quantity, but the new number that i
will input will be added to the previous number.

Hope you help me guysss.. more power.