Hi Max,

Who knows what they actually want <vbg. We have to overlay our assumptions
all the time, and the OP will probably never tell us :-)

Bob

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