View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandi Sandi is offline
external usenet poster
 
Posts: 42
Default Need Formula HELP

I have an Excel spreadsheet that has one column full of positive numbers and
negative numbers. I need a formula that will add up all the positive numbers
in one cell and all the negative numbers in another. I can do this by
selecting each cell one-by-one, but is there a faster way? It's a lot of
numbers to select one-by-one, that's why I am asking. THANKS :-)
--
Sandi Gardner