Take a look at =sumif() in excel's help:

=sumif(a2:a99,"0")
and
=sumif(a2:a99,"<0")

You could even put a value in another cell:

=sumif(a2:a99,"<"&b1)
to add up all the values less than the value in B1

ldiaz wrote:

I want to sum datas of a column with these Datas.

Usage Total Price
33.5 $65.5
-32.5 $-50.5
-1.5 $-5
1.5 $5

But I want to Sum only values upper 0. it should be: Usage Total: 35.5 &
$70.5

also I want the viceversa.

please help

ldiaz

--

Dave Peterson