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