Thanks for your reply.
I have a very large dataset that needs sifting.
For instance there are equal and opposite entries, i.e. debit and credit entries in 2 columns that may relate to the same product (say col3).
Hence I need a sumif equivalent to get rid of products that have net zero balance.