formula assistance.

[Trevor Tassell]

Hi im hoping someone here can help.Im struggling to get a formula written.

Below is my scinario.

I have a Mock up array (A3;F300)
in column c I would like to look up 3 criteria("Other spend PP," "Amazon pp", "Ebay PP")
Take the sum of their respective values from column E
Deduct that total from a specific cell(in this case H3)

Any assistance on this would be very much appreciated.

Thank you 

T.

[Swarup Modak]

G3 = SUMIFS(D:D, C:C, "Amazon PP") + SUMIFS(D:D, C:C, "Ebay PP") + SUMIFS(D:D, C:C, "Other Spend PP")

H3 = SUMIFS(E:E, C:C, "Amazon PP") + SUMIFS(D:D, C:C, "Ebay PP") + SUMIFS(D:D, C:C, "Other Spend PP")