Hi,

Use the formulas,

=SUMIF(A2:A100,"0") for summing positive quantities, and
=SUMIF(A2:A100,"<0") for summing negative quantities,

where A2:A100 is the range of cells considered. Modify the range
appropriately.

Regards,
B. R. Ramachandran

"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