How to use SUMPRODUCT FORMULA in MSexcel we want to know the total commission to be paid by us. One way of doing this is, you can calculate the commission of each employee differently in column E( Sales*Commission) and then add it together. But that will be too long so we use SUMPRODUCT function instead.