how to automatic count Total and Profit
- Thread starter Oscarr
- Start date
AlanSidman
Well-Known Member
Your explanation is a bit vague. Can you explain specifically step by step what you are trying to achieve
Hi, pls download my Attach file, after that you will know what i'm trying to achieve
AlanSidman
Well-Known Member
I have and it is not clear to me. Please explain step by step. I am not a mind reader.
example: client kent buy iphone 8 + Iphone x plus + mate 10 = total is 2188 profit is 847.34, so when i key in the red box there, i want it to utomatic count Total and Profit ...you click in that total and profit there can see the format, is 1 by 1 sum....
Attachments
AlanSidman
Well-Known Member
In K11 =SUMPRODUCT($D11:$I11*$D$7:$I$7) and copy down
In L11 =K11-SUMPRODUCT(D$11:I$11,$D$6:$I$6) and copy down
In L11 =K11-SUMPRODUCT(D$11:I$11,$D$6:$I$6) and copy down
|
hi @AlanSidman
In L11 =K11-SUMPRODUCT(D$11:I$11,$D$6:$I$6) and copy down , this one only deduct Cost, i want to deduct Cost/Box/Sticket, so Profit is 847,34.....
AlanSidman
Well-Known Member
L11 = =K12-SUMPRODUCT($D12:$I12,$D$6:$I$6)-SUMPRODUCT($D12:$I12,$D$4:$I$4) and copy down. If you were clear in your explanation using business terms instead of me trying to solve your puzzle, this would have been solved hours ago. In the future, explain your calculations in business terms so that we can clearly understand what you are doing. Mind reading is not my forte.
Sorry about that not explanation Clearly, because something so hard to explanation.......
Problem solve..thanks
Last edited: