need counting specific data on sheet

here the file
books5.xlsx

It's not clear why you can't just use SUM. A bit more explanation please

well is a little more easy add by programming because the data need to be up from the horizontal way first

Can you attach an example showing what the results will be

Roy_Cox SURE ! HERE IS!

That's a picture, a workbook is what's needed

Adriana, it would be extremely useful if you are posting follow up question to post links to the previous one.

Martin the color show make more clear to see the numbers because they a lot in the view
so make more easy

Grea Job !!

Roy_Cox thnks for you help good friend !

Martin the color show make more clear to see the numbers because they a lot in the view
so make more easy

Ok, if you need them, I'm willing to modify the code to add them, but to do so I'll need to understand why they have the colors they do. In other words tell me something like cell G17 is green because....

Ok, si los necesita, estoy dispuesto a modificar el código para agregarlos, pero para hacerlo necesitaré entender por qué tienen los colores que hacen. En otras palabras, dígame algo como la celda G17 es verde porque ....

Martin Great Job !
not special purpose in juts  it make more easy the view !

I want to make it easy. Tell me why the cell is green and I'll make it green.

Quiero que sea fácil. Dime por qué la celda es verde y lo haré verde.

Martin it not special purpose in
but i need help with others question i hope you can help me !!

Here's an update that adds the teal (trullo azul) color.
29019372a.xlsm

Martin ! Great Job !

Is a lot of code  i know is not easy !
TO MAKE IT HAPPENS !

that the reason a recomend to used the SELECT TO COUNTING sheet
so you have it summarize  for esay work in

Actually, the SELECT TO COUNTING sheet doesn't help at all. It is just a copy of the ORD columns from the "PREWVIEW" sheet, and so the only difference in the code would be the name of the sheet where the columns are (and different column letters).

En realidad, la hoja SELECT TO COUNTING no ayuda en absoluto. Es sólo una copia de las columnas ORD de la hoja "PREWVIEW", por lo que la única diferencia en el código sería el nombre de la hoja donde se encuentran las columnas (y las diferentes letras de columna).

New version with full color formatting!

Changes include:

• Corrected a problem with the MID column
• Formatted all cells in the 1W, 2W and ALL columns to be 2 digits. In other words "1" will be "01"
• Changed the way the teal color is produced. It now uses conditional formatting where perviously it didn't
• Added conditional formatting for the blue cells
• Added a sheet named "CF" which lets me to the conditional formatting

One last question. Why is cell B26 in your RESULTS COUNTING sheet purple. It's not conditional formatting.
29019372b.xlsm

Great work very admirable

You are one of the great experts of all time

Very responsible and reliable

Fixed.
29019372e.xlsm

MEGA GREAT ! JOB !

I LIKE IT !!