zbor and sweep helped me with a formula for counting how many positive and negative number there were on a sheet, (columns B & C). Could someone please explain how I can transfer the values to separate columns. I want to be able to establish an average of the positive and negative values, (columns D & E) http://screencast.com/t/guVkfWSDOm