Hi,

It would be a weird question, but i like to ask it with an example ...

21 22 23 24
23 24 25 26
27 28 29 30
21 21 21 21
25 26 27 28
20 20 20 20
22 22 22 22
26 27 28 29
25 25 25 25
26 27 28 29

in a template like this, from 10 rows and 4 columns, how can i see all
probabilities for the exact sum that is asked for ...

for example ...

21 -- -- --
-- 24 -- --
-- -- -- 30
-- -- -- 21
-- -- 28 --
20 -- -- --
-- -- 22 --
26 -- -- --
-- -- -- 25
-- 29 -- --
=x

-- -- -- 23
-- 24 -- --
-- -- 30 --
21 -- -- --
-- -- -- 28
22 -- -- --
-- -- 26 --
-- -- -- 25
-- 29 -- --
-- -- 30 --
=x

-- -- 22 --
-- 24 -- --
-- -- 30 --
-- -- 30 --
-- -- -- 28
22 -- -- --
30 -- -- --
-- -- -- 25
-- -- -- 23
-- -- 30 --
=x

as goes like this .......... i want to see all the results in this way
... as calculated in 10 colums and 1 row ...

i do not have any clue, how can i do this transaction ...

i need it for visual program's scripts ... for creative reasons ...

i would be so happy, if you can help me ...

yours turly ...


--
lynch44
------------------------------------------------------------------------
lynch44's Profile: http://www.excelforum.com/member.php...o&userid=33867
View this thread: http://www.excelforum.com/showthread...hreadid=536431