We have the credit card information of the customers. There are a cashback reward and sign up bonus.

We want the total cashback reward and sign up bonus paid. SUMPRODUCT() in conjunction with boolean to number conversion have been used.