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.
Site 3 Value
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!