Counting Pos and Neg #'s

[jimbob]

I have column with numbers that are both pos amd neg. I want to add u
all the pos #'s and divide by that number by the number that they occu
and do the same with neg #'s.

So if all pos# add up to 23.18 and pos #s occur 75 times I would b
dividing 23.18 by 75. And so on. Thanks again

 

[pinmaster]

Hi,
How about this:
=SUMIF(A1:A10,"<0")/COUNTIF(A1:A10,"<0")

HTH
JG

 

[Guest]

=sumif(a:a,">0",a:a) will total all the positive values; =countif(a:a,">0")
will tell you how many there are. So =sumif(a:a,">0",a:a)/countif(a:a,">0")
will give you the average of all the positives.
--Bruce

 

[Dana DeLouis]

Hi. Here's one way:

=SUMIF(Rng,">0")/COUNTIF(Rng,">0")

=SUMIF(Rng,"<0")/COUNTIF(Rng,"<0")

HTH

 

[Dana DeLouis]

....or the Array formula:

=AVERAGE(IF(Rng>0,Rng)) -> (Ctrl+Shift+Enter)