Adding only Negative values within range

[Ozzie]

Any idea how I can get the total of the negative values in
a table in B2 thru G8 (sample below)? Adding the
negatives gives -247. Is there a formula that would
accomplish this? My actual table is much larger and
changes each week.

1 -1 2 -2 3 -3
3 -3 5 -5 3 -3
60 -75 1 1 1 1
40 -50 1 1 1 1
30 -50 1 1 1 1
20 -50 1 1 1 1

Appreciate the help. If you want to email any ideas please
use the email addy above. Thanks.

 

[Vasant Nanavati]

=SUMIF(TheRange,"<0")

 

[Jason Morin]

=SUMIF(B2:G7,"<0")

If the range is dynamic, you'll have to use a different
formula to account for it.

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi Ozie
one way:
=SUMPRODUCT((B2:G9<0)*(B2:G9))

Frank

 

[Bob Phillips]

Ozzie,

Use SUMIF

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

(Altough I get -242!)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)