Dear All Expert,
my problem question is how to extract total sum value as belows number pattern at the cell.
the number pattern is: e.g.
A1 cell
987789 x 9, 789789 x 4, 000987, 987765, 888999 x 3 now i'd manually to add the total sum to get the total result is "18" at B1 cell
the result is came from like that "9", "4", "1", "1", "3", so total sum is "18"
because as above data input method to show how many set of item no.,
987789 have 9 sets
789789 have 4 sets
000987 only 1 set (so no mulitple "x") so count 1
987765 only 1 set (so no mulitple "x") so count 1
888999 have 3 sets
Sometimes maybe 3 items data, 098767, 898767 x 3, 567889 x 2 so total is "6"
Up to now, limited in my ability, i can't find a way to solve it!
Thanks,
my problem question is how to extract total sum value as belows number pattern at the cell.
the number pattern is: e.g.
A1 cell
987789 x 9, 789789 x 4, 000987, 987765, 888999 x 3 now i'd manually to add the total sum to get the total result is "18" at B1 cell
the result is came from like that "9", "4", "1", "1", "3", so total sum is "18"
because as above data input method to show how many set of item no.,
987789 have 9 sets
789789 have 4 sets
000987 only 1 set (so no mulitple "x") so count 1
987765 only 1 set (so no mulitple "x") so count 1
888999 have 3 sets
Sometimes maybe 3 items data, 098767, 898767 x 3, 567889 x 2 so total is "6"
Up to now, limited in my ability, i can't find a way to solve it!
Thanks,