detect and add the quantities of letters in their groups

[jorel]

detect and add the quantities of letters in their groups
https://www.excelforum.com/attachmen...1&d=1551180540

[Andy Pope]

Does it need to be VBA?

AW6: =COUNTIFS($I$4:$AU$4,AW$4,$I6:$AU6,"X")

[jorel]

Does it need to be VBA? YES!please

[Andy Pope]

one of many ways to do it

Please Login or Register  to view this content.

[jorel]

I put it in the worksheet, but it is not running! can you see why it is not performing?

[Andy Pope]

Why did you put the code in the worksheet module rather than a standard module?

What error did you get?

Post example of what you have done

[jorel]

I put the macro in visual basic (modulo) gave the command execute, and nothing happens

[Andy Pope]

As you don't want to show me yours I will show you mine.

Run the macro X to populate cells.

[jorel]

hello Andy has something strange in the macro, I did the correct procedures
* the macro is not happening at all, it's not running, it's not doing anything, please !!

[Andy Pope]

Did you enable macros?

Try clearing the output cells before running the code so you can see the new output.

[jorel]

hello, ANDY POPE! I cleaned the cells, I did the procedures, but this one is running, can you do it on the planilia sent in the post? please

[Andy Pope]

I did use the file you posted. I simply copied the code into it and saved with the thread number and .xlsm file format

[jorel]

hello ANDY !!!maybe it's a misunderstanding
* the amcro has to do on all lines
* those two are just an example
and more every week I'll post new drawings
* the macro has to do all blank, it's not doing this

[Andy Pope]

Not so much a misunderstanding as you never mentioned the amount of 'X' would change.

Please Login or Register  to view this content.

[jorel]

the sum of the suit does not work,
* the macro does not work, put it on the sheet
no excel

[Andy Pope]

Sum and correction

Please Login or Register  to view this content.

[jorel]

HELLO ANDY=It didn't work because it classed the X's as data, not the actual results. They were not all filled in for all the draws, so it stopped after 2 rows.
I had to do formulas to put the Xs in.

[jorel]

andy , andy!!It did not work because it classified the X as data, not actual results. They were not all filled for all raffles, so they stopped after 2 lines.
* You have to make formulas to put the Xs. The macro depended on counting how many rows of X there were to work correctly you have to change to count how many RESULTS there are.

Nor does the SUM part see this

[Andy Pope]

Please Login or Register  to view this content.

[jorel]

huu andy, perfect, magnificent work,
* Correct, now it's working,
thank you!