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))
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
help on using sumproduct
- Thread starter Kornelija
- Start date
PeteWright
Active Member
- Joined
- Dec 20, 2020
- Messages
- 423
- Office Version
- 365
- Platform
- Windows
- Mobile
Hello @Kornelija and welcome to the forums.
Without knowing what your data actually contains it is difficult to create a formula.
Could you please give an example with numbers or values or a screenshot of the cells you are referencing.
Without knowing what your data actually contains it is difficult to create a formula.
Could you please give an example with numbers or values or a screenshot of the cells you are referencing.
Upvote
0
Similar threads
- Question
- Question
- Question
