Summing all BUT one...

[popunonkok]

My problem is:

I like to sum all the numbers in a column exept the last post... The problem is that I will be adding numbers so the column will become longer and longer but its always the last post dont want to add to the sum.

Any one who can help me? (and who understands my problem)

//Peter F

[Biff]

Hi!

Try this:

=IF(COUNT(A:A),SUM(A:A)-LOOKUP(9.9999999999999E+307,A:A),"")

Biff

"popunonkok" <[email protected]> wrote
in message news:[email protected]...
>
> My problem is:
>
> I like to sum all the numbers in a column exept the last post... The
> problem is that I will be adding numbers so the column will become
> longer and longer but its always the last post dont want to add to the
> sum.
>
> Any one who can help me? (and who understands my problem)
>
> //Peter F
>
>
> --
> popunonkok
> ------------------------------------------------------------------------
> popunonkok's Profile:
> http://www.excelforum.com/member.php...o&userid=32858
> View this thread: http://www.excelforum.com/showthread...hreadid=535829
>

[popunonkok]

Thanks but that lead to a different question. Cant my Excel read english code because I got a Swedish version? For example the function SUM is SUMMA in Sweden. Excel gives me a error message with that code.

[Biff]

Sorry, I can't help translate.

There are a couple of regulars here that could probably do it but they would
have to see this thread.

Can you access this group:

microsoft.public.nl.office.excel

Or start a new post with a subject line of: translate formula to Swedish (or
something like that)

Biff

"popunonkok" <[email protected]> wrote
in message news:[email protected]...
>
> Thanks but that lead to a different question. Cant my Excel read english
> code because I got a Swedish version? For example the function SUM is
> SUMMA in Sweden. Excel gives me a error message with that code.
>
>
> --
> popunonkok
> ------------------------------------------------------------------------
> popunonkok's Profile:
> http://www.excelforum.com/member.php...o&userid=32858
> View this thread: http://www.excelforum.com/showthread...hreadid=535829
>

[Peo Sjoblom]

I am Swedish, here are the 2 not mentioned by the OP

COUNT = ANTAL
LOOKUP = LETAUPP

also note that commas are replaced by semicolons ;


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Biff" <[email protected]> wrote in message
news:[email protected]...
> Sorry, I can't help translate.
>
> There are a couple of regulars here that could probably do it but they
> would have to see this thread.
>
> Can you access this group:
>
> microsoft.public.nl.office.excel
>
> Or start a new post with a subject line of: translate formula to Swedish
> (or something like that)
>
> Biff
>
> "popunonkok" <[email protected]>
> wrote in message
> news:[email protected]...
>>
>> Thanks but that lead to a different question. Cant my Excel read english
>> code because I got a Swedish version? For example the function SUM is
>> SUMMA in Sweden. Excel gives me a error message with that code.
>>
>>
>> --
>> popunonkok
>> ------------------------------------------------------------------------
>> popunonkok's Profile:
>> http://www.excelforum.com/member.php...o&userid=32858
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=535829
>>
>
>

[Biff]

>I am Swedish

I had you in mind!

Biff

"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:[email protected]...
>I am Swedish, here are the 2 not mentioned by the OP
>
> COUNT = ANTAL
> LOOKUP = LETAUPP
>
> also note that commas are replaced by semicolons ;
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "Biff" <[email protected]> wrote in message
> news:[email protected]...
>> Sorry, I can't help translate.
>>
>> There are a couple of regulars here that could probably do it but they
>> would have to see this thread.
>>
>> Can you access this group:
>>
>> microsoft.public.nl.office.excel
>>
>> Or start a new post with a subject line of: translate formula to Swedish
>> (or something like that)
>>
>> Biff
>>
>> "popunonkok" <[email protected]>
>> wrote in message
>> news:[email protected]...
>>>
>>> Thanks but that lead to a different question. Cant my Excel read english
>>> code because I got a Swedish version? For example the function SUM is
>>> SUMMA in Sweden. Excel gives me a error message with that code.
>>>
>>>
>>> --
>>> popunonkok
>>> ------------------------------------------------------------------------
>>> popunonkok's Profile:
>>> http://www.excelforum.com/member.php...o&userid=32858
>>> View this thread:
>>> http://www.excelforum.com/showthread...hreadid=535829
>>>
>>
>>
>
>

[popunonkok]

First off, thanks for all the help...

But theres still something wrong, Peo S can you see whats wrong with this? Its far to advanced for me...

=OM(ANTAL(A:A);SUMMA(A:A)-LETAUPP(9.9999999999999E+307;A:A);"")

It sucks that I have to translate the code when I get loads of help here...

The code is for a doc that calculates how much fule my car "drinks"...

Thanks once again...