1 2 3
0 0 0
2 2 2
0 2 3
0 2 3
1 1 1
should be=5

- 2 -
0 0 0
2 2 2
0 - -
0 - -
1 1 1
=5

What sums op to 5? I don't see it! Yes, the middle column, but that doesn't match with your other examples. I'm afraid you'll have
to explain in words what you're trying to solve!

--
Kind regards,

Niek Otten


"lynch44" wrote in message
...
|
| i see that practice is the way ...
|
| here is other simple examples ...
|
| 1 2 3
| 1 2 3
| 2 2 2
| 1 1 1
| 1 1 1
| 1 1 1
| should be=5
|
| so there is no answers in this example ... because all exceeds 5 ...
|
| 1 2 3
| 0 0 0
| 2 2 2
| 0 2 3
| 0 2 3
| 1 1 1
| should be=5
|
| - 2 -
| 0 0 0
| 2 2 2
| 0 - -
| 0 - -
| 1 1 1
| =5
|
| OR
|
| 1 2 3
| 0 0 0
| 2 2 2
| 0 2 3
| 0 2 3
| 1 1 1
| should be=8
|
| - - 3
| 0 0 0
| 2 2 2
| - 2 -
| 0 - -
| 1 1 1
| =8
|
| 1 - -
| 0 0 0
| 2 2 2
| - 2 -
| - 2 -
| 1 1 1
| =8
|
| - 2 -
| 0 0 0
| 2 2 2
| - - 3
| 0 - -
| 1 1 1
| =8
|
| - 2 -
| 0 0 0
| 2 2 2
| 0 - -
| - - 3
| 1 1 1
| =8
|
| so forth ...
|
| i would like to see all probable vertical sums in this way ...
|
| simply i need the formula ...
|
| regards ...
|
|
| --
| lynch44
| ------------------------------------------------------------------------
| lynch44's Profile: http://www.excelforum.com/member.php...o&userid=33867
| View this thread: http://www.excelforum.com/showthread...hreadid=536431
|