In the same unit, the numbers are combined to calculate the su
Example : Cell D11 result 6Set , unit is Set , Total qty = 2+1+3
Can someone please help me ? It would be much appreciated. Thanks in advance
In the same unit, the numbers are combined to calculate the su
Example : Cell D11 result 6Set , unit is Set , Total qty = 2+1+3
Can someone please help me ? It would be much appreciated. Thanks in advance
Please explain the xample:
AliGW on MS365 Insider (Windows) 32 bit
A B 1 QTY UNIT 2 2Set 3 1Set 4 3Set 5 1Piece 6 1Box 7 1Box 8 1Box 9 1Box 10 116Set1Piece4Box
Sheet: Sheet1
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have tried to use this formula, Cell A11 is correct, but the others two are incorrect.
How can I modify the formula to get the correct ?
Formula:Please Login or Register to view this content.
Last edited by choletseng; 10-20-2021 at 08:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks