View Single Post
  #2   Report Post  
RagDyer
 
Posts: n/a
Default

If you want separate totals for each column:

=SUMIF(A2:A5,"0")
=SUMIF(B2:B5,"0")

=SUMIF(A2:A5,"<0")
=SUMIF(B2:B5,"<0")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"ldiaz" wrote in message
...

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