Hi Jonmo1,

Thank you very much for replying, the formula partly works but it also sums when there is an ID with "apple" and not "banana".
I would like it to sum the values of "apple" & "banana" when both are present within the same ID, if only one is present the result should be 0.

So in the example the results I am after in cells E2 to E5 are:

500
0
0
600

I've tried tweaking your formula but with no luck, can you help?

Thank you very much