Partially balance SUMIF records

exampleexcel.jpg

Hi all,

In this example each negative is a case of us being over stock (i.e. -12 equals 12 units over) and each postive is us missing stock (i.e. batch QO534175D15 missing 168). The goal is to adjust off records that balance out. Normally I would SUMIF and filter to only zeroes to find each SKU that balances and adjust off all records for that SKU.

In this case I want to find cases where I can partially adjust records. The -12, -384 and +396 could all be adjusted off to each other perfectly wile leaving the other variances behind. Is there a way I can SUMIF for records like these per SKU that partially balance?

Currently I manually sift through thousands of these records looking for lines that balance.

Thanks, Anth

Sorry bit of slang there, yes I want to flag the rows to delete.