Formula from Drop Down boxes

[TJVFree]

Hi,

I have a spread sheet I’m trying to come up with a formula that will add text to the totals box depending on the dropdowns that have been selected. There may be a total of 3 different text words depending on what words they pick from the drop downs. If only one word was selected for all the selections then only one word would show in the totals box.
Please see the attached for a better example.

Thank you for your time and help


TCB

 

[SkipVought]

Hi, attachment???

This would not be a spreadsheet solution. Please post in forum707 for VBA solutions.