Forum Discussion
Solved
Count by sizes
Hi, So what I am trying to do is have a pivot table or anything look at this information and tell me how many X is counted for each header. Example, I want to look at a table that shows for "The...
I was focused on the sample table and forgot about the size of the actual table. Hopefully the dynamic table will help to solve your task. In the meantime i noticed that i entered a criteria twice, column T and V are both for LR/L which is wrong.
Attached please find the corrected file with a control column (Y).
OliverScheurich because of all the sizes throughout the workbook I have. Yes I have small, medium and large, but will also have MS/S, MS/R, MS/L, MD/S, MD/R, MD/L, LR/S, LR/R, LR/L, XL/S, XL/R, XL/L, 2X/S, 2X/R, 2X/L, 3X/S, 3X/R and 3X/L for sizes for the uniforms for each person. Im about to test out the formula you provided. thank you again.
I was focused on the sample table and forgot about the size of the actual table. Hopefully the dynamic table will help to solve your task. In the meantime i noticed that i entered a criteria twice, column T and V are both for LR/L which is wrong.
Attached please find the corrected file with a control column (Y).
- thank you very much!