identify each letter and add up their quantities in each draw line.

[jorel]

identify each letter and add up their quantities in each draw line. please
https://www.excelforum.com/attachmen...1&d=1535804514

[alansidman]

please explain your criteria for your exercise. I have looked at it and it makes no sense to me. A clear explanation with examples may expedite a solution.

[jorel]

hello, think ALAN, it's as follows =
we have the draw line that has 7 numbers drawn
* 2nd step, was divided into 4 sectors, are 8 letters, the 8 letters are the same in the 4 sectors
* the macro will see the position of the corresponding letter in the 4 sectors or quadrants
* ex = if in the draw = we have 01 03 17 19 MEAN 4 letters (A) then the sum is 4 in the letter A
if the draw was not drawn = 02 04 18 20 are the number of the letter B then the sum is zero
* is easy

[alansidman]

I'm sorry, but that makes no sense to me. What do the other columns in have in relation to the Cubes. Nothing here appears logical. I'm going to pass on this. Hopefully, some one else will have an interest in figuring this out.

[jorel]

hello, thank you ALAN, the goal is to see the number of numbers in each of the 8 letters
and that letters zeroed and letters with quantities
each letter represented by a lottery number

[jorel]

hello, hi, alan, or others who want to help, you have look
* the matrix of numbers and letters, and the draw line,
to see how many numbers are drawn in each letter
* we have 8 letters and 4 seconds, one sector has seven letters, no problem
* objective is sums of times in each letter and position