=AVERAGE(IF(A1:A12<0,A1:A12))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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