Selectively averaging a column

[RandyB]

I have a column mostly of numbers (some text), and I want to average th
positive numbers separately from the negative numbers. An
suggestions? Thanks

 

[Ron de Bruin]

Try this

=SUMIF(A1:A10,">0")/(COUNTIF(A1:A10,">0"))

 

[Ken Wright]

=AVERAGE(IF(A1:A100>0,A1:A100)) array entered using CTRL+SHIFT+ENTER

and

=AVERAGE(IF(A1:A100<0,A1:A100)) array entered using CTRL+SHIFT+ENTER

This excludes 0s so you may want to adjust if you need to include them.

 

[RandyB]

Thanks, Ron, that works.

 

[RandyB]

Your's works, too, Ken. Thanks for the help.