One way
=SUMPRODUCT(--(A1:A40),A1:A4)
for total positive values - answer is 35 not 35.5

=SUMPRODUCT(--(A1:A4<0),A1:A4)
for total negative values - answer -34.0

Change ranges for price and alter range size to suit.

Regards

Roger Govier


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