Can anybody help me with this please:
I want to be able to calculate the total sum of column 'X' if column 'M' says 'Bound' and if column 'O' has a value greater than 0.
I have tried I few things including the below, however i cannot get it to work. If somebody could help me asap that would be much appreciated!
=SUMPRODUCT((M11:M25="Bound")+(O11:O25<0))*(X11:X25)
Thanks
Bookmarks