Thx that will help with part of my problem but how would I make A16
variable.........for instance.....the last cell I enter could be A17 not A16
but I don't want to keep going back to my formula to amend it........


"Ardus Petus" <[email protected]> wrote in message
news:[email protected]...
> To exclude cell A16:
> =SUM(A:A)-A16
>
> Not very elegant, but effcient!
>
> Cheers,
> --
> AP
>
> "DF2507" <[email protected]> a écrit dans le message de news:
> [email protected]...
>> 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
>>
>
>