"ras711" wrote in message
...
Sorry Sandy I forgot to be the array brackets

{=AVERAGE(IF(OpenData<0,OpenData,""))}

Array does yield the answer I was looking for.



I must have misundestood what you were saying, I thought that you were
saying that you managed to get the formula to work by simply enclosing the
range name in quotes:

ras711" wrote in message
...

It's ras again! Discovered my problem. When I was using the range name
OpenData within the regular average function I had to place quotes around
OpenData otherwise I got a #VALUE error.

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk