add the quantity in each of the three columns according to the matrix

jack

Member
add the quantity in each of the three columns according to the matrix
http://www.mediafire.com/file/t5ph0spapatv5va/sums_colum.xlsx
 

Frank

Member
I have looked at your spreadsheet and do not understand it.
I don’t know :-

1. What exactly is being counted or added. It’s is not clear which.

2. Where exactly is the result of that adding or counting placed?

3. What is the purpose of the question mark , there is no information to explain what you are doing.

More explanation required IN ONE SINGLE POST.

Think carefully before posting, complicate this and I will walk away.
 

jack

Member
Okay, thank you, okay look, we have the lottery
* converted into numbers from 01 to 42 in three columns (1x2)
* we have three columns column one (playing time at home) middle column (x) and column two
in each draw line there will be the sum of the markings
* the macro has look at the array from 01 to 42
the sum will always have 14, for 14 games of the teams
* each draw line will have a suit and the sum will always be 14
ex = column 1= 8 middle column (x)= 2, and column two= 4 then 8,2,4 = 14
* the question mark is mere to continue
please
 

jack

Member
matriz 01 a 42= 14 games
1 X 2
1 2 3
4 5 6
7 8 9
10 11 12
13 14 15
16 17 18
19 20 21
22 23 24
25 26 27
28 29 30
31 32 33
34 35 36
37 38 39
40 41 42
 

Frank

Member
Well I did warn you. Too complicated, not properly explained, I have no idea what you are doing.
Im out.
 

jack

Member
frank, we have the matrix with three columns
* and we have each draw line
* is to see the corresponding quantity
 

Sidebar

Top