Hello I am hoping someone online here can help me with my delima.

I have a huge worksheet of values in US dollars, and these values are both
positive and negitive. I would like to know if their is a way to eliminate
the lines which cancel each other out. Bascially I am trying to sum the
values but eliminate the values which cancel each other out.

For example line 10 is $100
line 200 is -$100

Is there some type of function i can use to eliminate all values which sum
to 0 ?

Thanks in advance for any help or advice offered

Cheers,

Terry