I would like to know 2 things.

Firstly, how do I create a drop down list.

Secondly, how can I format a cell to recognise a word on the spreadsheeet
and then calculate the number on the same line. I would like it to
consolidate several figures and then give me at total, but it will need to
recognise the word first.

Cheers....

MickM