sum quantity existing value in subtable

hi, i have a question, i’ve created a sheet with my inventory all product have a unique EAN code, i have created a new sheet “inventory update” beacuse periodicly i want check the quantity of the inventary.

and i want this:

EAN CODE 00001 quantity 1
EAN CODE 00002 quantity 2
EAN CODE 00003 quantity 2

EAN CODE 00001 quantity 1 (i want sum this quantity at the first line because EAN is existing and not show this)

is possible? thanks


Can you allow the Ragic support staff access to your account so we can have a look at your current sheet design?

You can allow access by clicking the “Need Help” link on the upper-right side of your account and filling the form.