=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

"jimbob" wrote:


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

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


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488491