Source: psycnet.apa.org
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 negitive
0.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:
Hello
Try these
= COUNTIF(A1:A34,">0")
and
= COUNTIF ("A1: A34"),
Home
Add Your Article
Categories
Search Something
Latest Buzz
Related Buzz
0 Comments