One way:

=SUMIF(B1:B100,"0")/COUNTIF(B1:B100,"0")
=SUMIF(B1:B100,"<0")/COUNTIF(B1:B100,"<0")

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Bruce" wrote in message
...
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