excell RRS feed

  • Question

  • I want to sum a column of numbers which contain negative numbers. I want to ignore the sign and sum the entire column. I other words, if I have a column with the number 10 in ten rows, the sum is 100. That I know how to do, but if I convert one of the numbers (ie -10) I get 80. I want to ignore the sign and total to 100. Can you help.
    Monday, October 31, 2011 4:38 PM


  • Can you please post it at some excel forum?


    Lev Nachmanson
    Monday, October 31, 2011 8:32 PM