Thanks - had a blank out for a minute - much appreciated

Nick

"JE McGimpsey" wrote in message
...
One way:

=SUMIF(1:1, "0")

In article ,
"Nick Wakeham" wrote:

I would like to add up all the data in a row excluding any entry that is
in
the minus. Is this possible?
Nick