Counting Pos and Neg #'s

  • Thread starter Thread starter jimbob
  • Start date Start date
J

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
 
=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
 
Hi. Here's one way:

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

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

HTH
 
Back
Top