Forum Discussion
Sharon_Murphy
Dec 16, 2020Copper Contributor
Excel Lookup a separate table and return the sum of a product code
Hi is it possible to have an excel sheet with 2 tabs. The first tab has rows of data containing a list of codes and amounts, for example
Date Code Supplier Amount
On the second tab I want to put the code and the sum of the amounts; for example
Code Total
Is this possible by using a lookup function - I've attached the file