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

Vaya con Dios,
Chuck, CABGx3



"martins" wrote:


Yep - does the trick - was also wondering how you would allow for a
minus figure within the list of cells to add, as occasionally this does
happen -


--
martins
------------------------------------------------------------------------
martins's Profile: http://www.excelforum.com/member.php...o&userid=31616
View this thread: http://www.excelforum.com/showthread...hreadid=526065