Forum Discussion

Sharon_Murphy's avatar
Sharon_Murphy
Copper Contributor
Dec 16, 2020

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

Resources