How I build a formula where I just consider from a data base only.

W

Wilnelia

Im trying to build a formula to sum all the negatives values in a data base.
PLease help me with this.
 
D

Domenic

Wilnelia said:
Im trying to build a formula to sum all the negatives values in a data base.
PLease help me with this.

=SUMIF(A1:A10,"<0")

Hope this helps!
 
J

Jason Morin

Example: Sum all negative values in col. A.

=SUMIF(A:A,"<0")

HTH
Jason
Atlanta, GA
 
D

Don Guillett

A simple sumif should do it
=SUMIF(D:D,"<0")
if you want a positive number

=abs(SUMIF(D:D,"<0"))
or
=-SUMIF(D:D,"<0")
 
Top