Calculation with multiple sheets and search results.

[magicmutte]

Hi,
I'm new here so apologies if this is in the wrong category.
I have been struggeling with a problem similar to the one in attachment.
In one sheet I have a brief overview of a product (with reference number)
On the other I have information about the different costs.
There are multiple costs per reference number.

My objective is to find a solution that allows me to:
1: get a total of all the costs for 1 reference number.
2: get the cost of 1 specific cost for 1 reference number.

I have tried several methods to get a result like vlookup of index/match but I keep bouncing against a wall.
for some reason I can only get 1 result instead of the sum of results.

I hope I made myself clear enough.
Many thanks in advance



I solved this myself (after days of searching) using the SUMIFS function.
Thanks anyway