Just reverse that inequity sign:

=SUMIF(B3:I3,"<0",B3:I3)



Knold10 wrote:

I just read this. How about adding the negative numbers?

"Ruthki" wrote:


try

=SUMIF(B3:I3,"0",B3:I3)


where b3:I3 are the range you are testing and summing.

R


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=391529



--

Dave Peterson