average by operand

[Bruce]

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

 

[RagDyer]

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!
==============================================

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

 

[BenjieLop]

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 are:

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

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

 

[Ken Wright]

=AVERAGE(IF(A1:A20>0,A1:A20))
=AVERAGE(IF(A1:A20<0,A1:A20))

array entered using CTRL+SHIFT+ENTER, but what about the 0s, don't they fall
into one of the camps