Link to home
Start Free TrialLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

need counting specific data on sheet

need to count this numbers in this order
User generated image
any help please?
Avatar of ADRIANA P
ADRIANA P
Flag of United States of America image

ASKER

here the file
books5.xlsx
Avatar of Roy Cox
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!
User generated image
That's a picture, a workbook is what's needed
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
User generated image
MEGA GREAT ! JOB !
I LIKE IT !!