Macro that finds all cells which add up to zero

[S1n1]

Hi,

Is it possible to write macro which finds all cells that add up to zero? Thank you!
A
1
2
3
4
-5
6
7
8
9
10
-17
-8

[patel45]

do you mean finds all cells with value > zero ? and then ?

[ARGK]

Hi
What do you want to do when you have found the cells that = "0"? Or are you saying that you want to count the number of cells that = "0".
Tony

[S1n1]

Hi, I would like to get the cells which sum is zero in all combinations. For example, in this case it would be 10+7-17=0 or 2+3-5=0

[S1n1]

If it would be possible to get for example in different colours them or copy the values in other column.

[XOR LX]

"For example, in this case it would be 10+7-17=0 or 2+3-5=0"

So you're restricting your number of summands to three? Otherwise:

1+2+3+4+6+9-17-8=0

is another one of potentially thousands of solutions (never mind the fact that you don't mention whether each value may be used more than once).

Regards

[S1n1]

For me the one most important thing is to find one way to get zero, doesn't matter from which numbers exactly.

[S1n1]

The most important thing is to find anything which sums to zero. because I have huge amount of data.

[S1n1]

At least it can find one, it's ok for me as well, because i have huge amount of data.

[patel45]

try attached file

[S1n1]

Works amazing, thank you!