Sum values based on multiple criterias in a list.

Hi,

Id be pleased if someone could help me with a sum function. This might be easy, but I just cant wrap my head around it.

I have a list of uniqe IDs. To each ID there is multiple values based on the header, ie. "10", "20", "30".

So for example, i want to SUM only "10", "20" and "30" for "0101 Halden", as this are the ones named in the "Cost list".
I could do it manually, but eventually there will be different combinations with many numbers in the list.

Hopefully i've managed to explain what Im looking for. Thanks

L.

Hi, thanks for a quick answer.

There might be a chance that Im not understanding your formula.
But as far as I can see, it only add together those under "10". I want it to sum all values that are in the list called "Cost (list)". That means i want it to sum "10", "20" and "30" also.

That last one was excatly what I was looking for. You haved saved me from a lot of fumbling around doing manual "labour".
Thank you very much!