Exclude a cell again

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
>>
>
>

one way where you are looking for a number larger than possible in your
column.
=SUM(INDIRECT("a2:a"&MATCH(9999999,a:a)))

--
Don Guillett
SalesAid Software
[email protected]
"DF2507" <[email protected]> wrote in message
news:[email protected]...
> 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
>>>
>>
>>
>
>
>

It's really best to stay with your original thread.
This prevents others who wish to help from duplicating already suggested
solutions.

http://tinyurl.com/j74o3

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"DF2507" <[email protected]> wrote in message
news:[email protected]...
> 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
> >>
> >
> >
>
>
>