Sort Type and Size Excel formula [Closed]

Report
Posts
1
Registration date
Monday February 8, 2016
Status
Member
Last seen
February 8, 2016
-
Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
-
Hello, can someone please help?
I'm trying to write a formula that would sort Type and Size on the following spreadsheet which has the following:

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 my spread sheet has 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 at the bottom of the spreadsheet?
Thank you in advance for your assistance

1 reply

Posts
2670
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 22, 2020
446
Hi mszez,

To know the amount of Male (column A), size 4XL (Column D) use:
=SUM((A2:A330="x")*(D2:D330="x"))
This is a so called array formula and needs to be confirmed by hitting Ctrl+Shift+Enter. When done correctly the formula will be enclosed by curly brackets {}.

Change the column references for the other Type and Size combinations.

Best regards,
Trowa