Example: Apple
Because STORE1 appears apple , STORE2 appears watermelon, so item2 has a total of 200, which must be divided by 2, and finally each will be 100
If the names of Store1 and store2 fruits appear separately, they will each account for half of them.
J2: J9 How to write the formula?
Thanks for any help!
Last edited by rayhen; 12-06-2020 at 07:43 AM.
Try this in J2:
=SUM(IF($B$2:$B$11=I2,$D$2:$D$11/(1+($C$2:$C$11<>""))),IF($C$2:$C$11=I2,$D$2:$D$11/(1+($B$2:$B$11<>""))))
Enter with Ctrl+Shift+Enter.
Awesome, that does the trick! Much appreciated! Phuocam tqvm
J2 cell formular , Copy and drag down
HTML Code:
@wk9128 Much appreciated! Tqvm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks