total count of positive and negitive results numbers in a range of cells

Office

Question:HI: is there an equation of excel for the total count of positive numbers and negitive results in a range of cells?Example of how much and how many positive results of negitive0.1% 0.2% 1.1%-0. 5%-0.1% 0.7%-0. 7% 0.1% 0.2% 0.2% 0.0% 1.5% 0.1% 0.9% 0.0%-0. 3%-0.2%-0 6% 0.9%-0. 1% 0.0% 0.1% 0.5% 1.1% 0.4%-0. 5% 0.2% 0.0% 0.9% 0.2%-0. 3% 0.3% 0.0% 1.5%Answer:HelloTry these= COUNTIF(A1:A34,">...Read More

Posted: 22 Feb 2012

Tags: total count of positive and negitive results numbers in a range of cells total count positive and negitive results numbers range cells