I got £186,591.91 from my total sales figures, along with £1,037,706.78 for Revenue and £851,114.87 for my Costs.
This was done with all advertising options open and out of the shops open, only Newquay and Land's End were chosen to give me my total profit.
all other shops were closed. Falmouth was open to begin with. You cannot change this.
I have made no loss in the 'Monthly Figures' sheet which is a good sign.
To do the Advertising section, you have to do an IF Statement. To do this, just enter =IF(Values!$B7="Yes",B7,0)
this formula should make the Falmouth advertising work for you. If it doesn't, your spreadsheet is wrong, somehow.
Hope this helped and if you have a greater profit than me, please let me know how to get it.
Thanks.
¬Adam Kehoe¬