Forum Discussion
Formula to get total number of multiple products
I am trying to get a formula to gather the total each piece of multiple products. For example, someone orders from us 10 of the option 1 grab bag and 10 of the option 3 grab bag. Both bags have 1 blu...
ANSWER: Create an Excel Table that shows the contents of each grab bag in a row.
That's a general answer to a general question.
If you'd like more specific help, you'd help us help you by attaching a copy of whatever kind of spreadsheet you've got going so far. It would help to know how many other things are in each grab bag, what the maximum number of distinct components is now, is expected to be.