"Bob Phillips" wrote:
=SUMIF(A1:A10,"0")+SUMIF(B1:B10,"<0")
Not sure if this will return what the OP wants <g
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----