Depending what and where totals appear

=SUM(IF(a1:a10<0,IF(ISNUMBER(a1:a10),a1:a10,"")))

Entered as an array shift ctrl enter

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=400698