Adding only Negative values within range

  • Thread starter Thread starter Ozzie
  • Start date Start date
O

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.
 
=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
 
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)
 
Back
Top