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?
Bookmarks