The first line, A 1 input size, B 1 input gender, and C 1 input summary, forms the following table:
Size gender summary
XXXL male
XXL male
XL people
L male
man
XXXL female
XXL female
XL female
L female
men and women
Enter the following formula in C2:
=SUMPRODUCT((Sheet 1！ $ B $ 2:$ B $ 10000 = $ A2)*(sheet 1！ $ C $ 2:$ C $ 10000 = $ B2)* sheet 1！ $D$2:$D$ 10000) drop down menu.