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
Bookmarks