Hi!

Try this:

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

Biff

"popunonkok" wrote
in message ...

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