I would like to calculate the total revenue using a formula incorporating sumproduct but I'm not sure how to go about it. I was wondering if it's possible to subtract within sumproduct? (The question specifically asks me to calculate the total revenue using sumproduct). For example SUMPRODUCT=((M1:M100,K1:K100)-(N1-N100,L1:L100))