Summing all BUT one...

[popunonkok]

My problem is:

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

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

//Peter

 

[Biff]

Hi!

Try this:

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

Biff

 

[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

 

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

I am Swedish

I had you in mind!

Biff

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

 

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