Exclude a cell

[DF2507]

Excel 2002

Any one know how I can sum all the cell values in a column except the value
of the last cell to be entered which could be say half-way down the column?

Is there a function to exclude a particular cell from "sum" ?

I know a lot of ppl are far more advanced than I am but we all start
somewhere lol

Thanks for your help

Dale

 

[Ardus Petus]

To exclude cell A16:
=SUM(A:A)-A16

Not very elegant, but effcient!

Cheers,