Make sure that your numbers are actually numerical values. Try the
following...

1) Select an empty cell

2) Edit Copy

3) Select your range of numbers

4) Edit Paste Special Add Ok

Does this help?

In article ,
"Sam via OfficeKB.com" wrote:

Hi Domenic,

Yes, there are some blank cells at the end. I've tried the Formula below but
I now get a much lower value than I should.

Thanks
Sam