Thank you guys, all sorted now. Saved me from pulling my hair out.

I had got =SUM as this is what I was using previously. This is why I was going around in circles trying to get this to work.

Anyhow thank you very much for your help. It's much appreciated.

Regards
Luke