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.
