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