If 6 purple shirts are for men, how many are medium?

[themil]

I can't seem to put this question into terms that give me a result on Google; seems like an old common question from primary school!
I'm getting results online that get me half way but I don't know the correct terminology to get me either further or the answer. I've tried AND and OR statements and just get errors on my end.


I have a sheet full of data for t-shirts. Columns are split into 5 for colours, then 1 for gender, and 1 for size eg: purple, blue, green, orange, pink, gender, size.


How can I get a value from this question,


If I have 9 purple shirts: =sum(B2:B28)


6 are for men: =SUMIF(G2:G28,"M",B2:B28)


How many are Medium? How many are Large? Small, etc. etc.


Am I splitting everything correctly for the data? Anything wrong?

Only reason for doing this is because each time I order it's going to double each time and soon will get out of hand.
Screenshot attached.

My brain is mush trying to answer this. Beyond my expertise!

Thank you in advanced.
Michael.

 

[Comfy]

The SUMIFS formula should do the trick.

Purple shirts, Male, Medium would be:

=sumifs(B2:B11,G2:G11,"M",H2:H11, "M")

 

[themil]

I am crying tears of happiness! Thank you @Comfy!