Thanks for the reply and yes, I'll try using those first before I move on!

Just one more thing, can I locate the cell with the total in it anywhere? How do I 'land' it where I want it? ...maybe remote from the series I want to sum. I've successfully cut and pasted it but is there another, better way?

I've used the click and highlight method for summing contiguous cells but I always get the final total box at the bottom of the column of numbers.