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).
=COUNTIF(OFFSET(A2:A7,0,MATCH(A11,A1:H1,0)-1),A10)
Is this what you are looking for? Enter small, medium, large... in A10 and thermal shirt, thermal bott, gloves... in A11.
I will definitely look at this after I get from my appointment, thank you for you help