Bruce Wrote:
I have a column with percentages that are positive and negative.
How do I calculate the Average of the postive's and an Average of the
Negatives?

Bruce


If the numbers are in, say, A1:A100, then your formulas a

For the positives: =sumif(A1:A100,"0")/countif(A1:A100,"0")

For the negatives, just simply replace "0" with "<0"


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=275508