Hi

I have these numbers in a column

-0,05%
1,27%
1,22%
-0,89%
0,19%
0,26%
-0,19%
1,48%
0,77%
-1,11%
-1,20%
0,11%

1)

I want to single out the negative number - add them together - and
display the avarage in a cell

2)

In another cell I want to single out the positive numbers - add them
together - and display the avarage

Sorry if this has been asked before. Please be kind

Thanks!

Kitty