View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
popunonkok
 
Posts: n/a
Default Summing all BUT one...


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


--
popunonkok
------------------------------------------------------------------------
popunonkok's Profile: http://www.excelforum.com/member.php...o&userid=32858
View this thread: http://www.excelforum.com/showthread...hreadid=535829