T-Shirts [Closed]

Report
-
Hello,
I have 3 columns Male, Female AND Long Sleeve, I then have 7 columns of sizes 4XL, 3XL, 2XL, XL, L, M, S. If and x is placed in one of the 3 columns for TYPE {say Male} and on the same row an x is placed in the size (SAY S) and I have 330 rows, what would be the formula so that I can get a value of TYPE and SIZE on all 330 rows with the SIZE compared to the TYPE????