Calculate combis and then multiply by cell values

[faris al farik]

\1

Hi, I was wondering if anyone could help me to make something along the lines the simplistic view I have posted above.

I would like to be able to change the number of items and the combis.
Then to multiply through the various combinations to give a product of each combi selected.

Would this be even possible? I would greatly appreciate any help on this?



Regards


edit: apologies, I can't get the picture to post in the thread, it will only link unfortunately, my browser crashes when I use the insert image tool

[pike]

Welcome to Excel Forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!