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
