Hi there

I need a formula to sum the values in a range of cells where the cells contain both text and values together. The values are a currency value.

Below is a basic example.

I understand I may also need to use VBA?

Many thanks

Monday: "Breakfast £100
Lunch £50"
Tuesday: "Breakfast £100
Lunch £50"
Wednesday: "Breakfast £100
Lunch £50
Dinner £150"



TOTAL FORMULA?