Returning the sum of numerous cells based on multiple look up criteria.

So I have attached an example of what I'm after.

In the example I have the formula in cell G2 which is returning the sum of values in column D that match with the criteria in columns A, B & C. The specified criteria is in cells F2, F3 and H2. Whilst the data in columns A & B will only search against one criteria (F2 & F3), I want the formula to search the data in column C and return all values that match more than one criteria.

In the current example the formula returns £77 because that is the sum of D2 & D6. What I want it to do is return £144 because it would also sum D8 as the

Currently I am using a sumproduct formula but I suspect this may have to be changed.

This has been killing me and any help would be greatly appreciated!

Cheers,

Chris