software

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: www.excelforum.com/member.php...oamp;userid=32858
View this thread: www.excelforum.com/showthread...hreadid=535829Hi!

Try this:

=IF(COUNT(A:A),SUM(A:A)-LOOKUP(9.9999999999999E 307,A:A),quot;quot;)

Biff

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

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: www.excelforum.com/member.php...oamp;userid=32858
View this thread: www.excelforum.com/showthread...hreadid=535829Sorry, 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

quot;popunonkokquot; gt; wrote
in message news
gt;
gt; Thanks but that lead to a different question. Cant my Excel read english
gt; code because I got a Swedish version? For example the function SUM is
gt; SUMMA in Sweden. Excel gives me a error message with that code.
gt;
gt;
gt; --
gt; popunonkok
gt; ------------------------------------------------------------------------
gt; popunonkok's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32858
gt; View this thread: www.excelforum.com/showthread...hreadid=535829
gt;
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

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

I had you in mind!

Biff

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

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);quot;quot;)

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 quot;drinksquot;...

Thanks once again...--
popunonkok
------------------------------------------------------------------------
popunonkok's Profile: www.excelforum.com/member.php...oamp;userid=32858
View this thread: www.excelforum.com/showthread...hreadid=535829