Let's say you have:
column A: name of student/adult
column B: size
column C: class
I will further assume there are 100 entries
Not to worry, you will be able to work with my ideas even with different
setup.
First make sure that row 1 had labels (Name, Size, Class) You can easily
insert a row - right click the 1 row header and use insert row; now add
labels. So the first name is in A1 and the last in A101.
Second: Select everything and use Data Sort. The first sort is by class, the
second by size.
Third to get the counts (works even without sorting)
In F1, H1, G1 ..... enter the sizes
In E2, E3, E4... enter the class names
In F2 enter =SUMPROUDCT(--(B2:B101=F$1),--(C2:C101=$E2))
Adjust to match you actual ranges.
This will tell how many order there are for the first named class and the
first named size.
Copy along to cover all sizes and down to colver all rows.
I expect you know how to use AutoSum to insert =SUM(....) to get totals for
rows and columns
If your set up is very different or anything is unclear please come back.
I'll have an XXXL please
best wishes
