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
>
>