I have approximately 3000 lines of data that includes both positive and
negative numbers. This represents a clearing acount that does not clear to
zero as it should. Of the 3000 lines I have approx 100 of these that are
negative numbers. I need to find out what Positive numbers match the
negative numbers to zero when added. There are no formulas in this sheet.
Can Excel give me that answer?