Hello,

I apologise in advance for what is probably quite a simple problem, but any help is appreciated.

I have 2 arrays of data which I'd like to use (B3:B136 & H3:H136), my goal is to do the sumproduct of these 2 arrays IF the figure in H is >0.

Heres a small example:

£20 -1
£15 0
£10 1
£5 2

I would want the result to be £20 (10*1 + 5*2).

Many thanks