separate the start and end digits and high and low digits and *

I don't know if I understand what you are looking for, but here is my best guess.

For first/last:
I5: =SUMPRODUCT(--(LEFT(TEXT($A5:$G5,"00"),1)=TEXT(I$4,"0")))
N5: =SUMPRODUCT(--(RIGHT(TEXT($A5:$G5,"00"),1)=TEXT(N$4,"0")))
Then copy right and down.

For Even/Odd and High/Low, I think you can just use SUMIFS once you have the first/last formulas in place, but my results didn't quite match yours, so I don't know if I understood your request correctly.

Y5: =SUMIF($I$4:$W$4,Y$4,$I5:$W5)

Copy right and into AE, AK, and AQ, then fill down.

Take a look at the attachment to see if it's working as desired.

Originally Posted by jorel

error = 0 0 0 2 0 38 corret 16

As I mentioned in my initial response, I don't fully understand your request. If my solution works in some parts but not in others, please be very clear about where it isn't working and what is should be doing instead.

If your are referring to AQ6:AV6, my solution in post #2 completely ignored the SUM columns. I do not see what pattern or calculation you were aiming for with those columns. If the incorrect results are occurring in SUM columns, please clarify what they are supposed to be summing. My best guess is that the SUM column is supposed add the tallies multiplied by their values, but in some SUM columns the 'expected' value you included in your initial attachment doesn't match that calculation. If you want the tally*value total, try using SUMPRODUCT:

For example, in M5: =SUMPRODUCT(I$4:L$4,I5:L5)

Originally Posted by jorel

only missing now quanvou put new raffles the macro has to do automatic, in fact in all scenilia always will place new raffles

I'm glad I could help, but I don't understand this sentence. My guess is that you are looking for a macro that randomly creates the six raffle numbers on each rows? If I am correct, you do not need a macro. In the attachment, I've created the random raffle numbers in AY:BE using the formula below in AY5. It must be array-entered (confirmed with Ctrl + Shift + Enter instead of Enter), then filled right and down:

=INDEX(SMALL(IF(ROW($1:$39)*(COUNTIF($AX5:AX5,ROW($1:$39))=0),ROW($1:$39)),ROW($1:$39)),RANDBETWEEN(1,40-COLUMN(A:A)))

To get the numbers in order in A:G, use the formula below in A5 (NOT array-entered), then fill right and down:

=SMALL($AY5:$BE5,COLUMN(A:A))

You can re-randomize the numbers by pressing F9. Take a look at the attachment to see if it is what you want:

I'm sorry, I still don't understand. Can you attach a workbook that demonstrates what the data should look like both 'before' and 'after' the help you're requesting?

Are you just looking to move the formulas down to a new row? You can either select I:U of the bottom row and fill down through the new row, or you can add an IF($A5="","", … clause in front of every formula and fill them down beyond what you need so that the formulas will automatically populate when you add new rows to A:G. Will that work? The attachment demonstrates the second way:

Happy to help, good luck!