Excel Lookup a separate table and return the sum of a product code

Copper Contributor

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

1 Reply

@Sharon_Murphy 

 

This is the formula you want:

=SUMPRODUCT(--(Data!B:B=A2),Data!D:D)