Hi,

Does this help

If you select the range plus 1 x blank cell then press F5 and select Blank cells you can then click on the sum function

E.g If A1 to A100 is your range then select A1 to A101

VBA Noob