MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding only the negative values


Posted by mcs on April 02, 2001 2:30 PM

I have a spreadsheet that does some analysis on items. It evaluates production against demand to determine the difference. I have 30 demand sites. I need it to add up the deficit sites, but ONLY the deficit sites.

Example

Item XXX'
Site 1
Prod
Demand
Value

Site 2
Prod
Demand
Value

Site 3 Value
Prod
Demand

If 1 and 3 are negative and 2 positive I want only the value of 1 and 3.

Is there a way to do that? Thanks in advance!


Posted by Mark W. on April 02, 2001 2:34 PM

=SUMIF(ref,"<0")

Posted by Dave Hawley on April 02, 2001 2:35 PM


Hi mcs

How about:
=SUMIF(C1:C20,"<0")


Dave

OzGrid Business Applications