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

Wilnelia · Sep 23, 2004

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

Domenic · Sep 23, 2004

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!

Jason Morin · Sep 23, 2004

Example: Sum all negative values in col. A.

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

HTH
Jason
Atlanta, GA

mzehr · Sep 23, 2004

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

Don Guillett · Sep 23, 2004

A simple sumif should do it
=SUMIF(D

,"<0")
if you want a positive number

=abs(SUMIF(D

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

,"<0")