formula for calculation
I have an inquiry regarding formula for calculation. As attached, on the right side of the layout, I created drop down list for Item. In the list, user can select varieties of Item(eg: Mouse, Scanner, Printer, Monitor, Ink etc...). In the same table, user can key in the quantity of number that the user owned for each Item on selected date.
As you can see on the left side of the layout, I would like to create the total unit/quantity of each item of the user owned. May I know how can I do that?
Thank you very much.