View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lowan Chan Lowan Chan is offline
external usenet poster
 
Posts: 22
Default sum up two result in one column

How can I sum up numbers which are 0 and <0 respectively in one column?
e.g. in Column A, I have

12
-46
90
32
-56
-34

how can I set the fomula that only minus number are sumed up?

thanks.
--
Lowan