Average Positive numbers and Average negative numbers from columns G4 to G14

[PhilipeC]

I would like to calculate the average positive numbers and average negative numbers from colums G4 to G14.

 

[JoeMo]

For positive numbers:

=AVERAGEIF(G4:G14,">=0")

For negative numbers:

=AVERAGEIF(G4:G14,"<0")

 

[Peter_SSs]

For positive numbers:

=AVERAGEIF(G4:G14,">=0")

Assuming that the question was asked accurately, that would actually be
=AVERAGEIF(G4:G14,">0")

 

[JoeMo]

Assuming that the question was asked accurately, that would actually be
=AVERAGEIF(G4:G14,">0")

OP didn't say if zeroes should be included. I assumed they should be.

 

[Peter_SSs]

OP didn't say if zeroes should be included. I assumed they should be.

But the OP did say they wanted to average the positive numbers, which zero is not a member of.