Excel 2007 Count Multiple Selections from a List Box

[KJ2607]

Hi

I've created a List Box via form controls so I can select more than one option i.e. Train, Bus, Car, Bicycle, Walk.

There will be times when the user will select more than one option in each cell and I need to count the total number of Trains, Bus, Car etc down the column.

Is it possible to write a COUNT formula to only count the number of individual selections that occur down the column?

Not sure if this makes sense?

Thanks for any help in advance!