Just looked again and my problem is I have been doing the formula by clicking on c7 instead just typing it, so thank you it works fine. Obviously just a blonde moment this brunette was having lol.

Thanks for your help,
Gemma