I got a column of unique article numbers on a Sheet called 'Summary'.
Column A Column B
Article_No Total Numbers of Units Sold
90-443 40 ('to be retrieved from Sheet 'Sales')
Another worksheet called 'Sales' lists these article numbers often several times with the corresponding units sold
Article_No Units Sold
I now would like to make a lookup on Sheet 'Summary', i.e. a formula ...
... should lookup all the hits for a give article number on Sheet 'Sales' and ...
... then sum up the units sold and display them in Column B on Sheet 'Summary'
Is this possible using a formula? That would be great.
Help is much appreciated. Thank you very much in advance.