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

[Guest]

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

 

[Domenic]

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!

 

[Jason Morin]

Example: Sum all negative values in col. A.

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

HTH
Jason
Atlanta, GA

 

[mzehr]

Hi,
Try some variant of the following
=SUMIF(A1:E1000,"<0",a1:e1000)

 

[Don Guillett]

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

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