you wont able able to sum the whole column if the total is in it, but you can have some kind of larger range you just put the total elsewhere in the workbook



Can you post an example so we can understand the layout a bit better?