Excel 2007 formula question

[Nick Wakeham]

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

 

[Dave F]

=SUMIF([row],">0")

Dave

 

[JE McGimpsey]

One way:

=SUMIF(1:1, ">0")

 

[Nick Wakeham]

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

Nick