View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
zzapper zzapper is offline
external usenet poster
 
Posts: 3
Default How to sum only positive values in a column?

Hi
given a column say

10
-2
5.53
5.2
-27

How to sum ignoring the -2 -27 etc


(and then how to sum only the negatives)

--
zzapper
Best of VimTips
http://www.vim.org/tips/tip.php?tip_id=305