Sort Type and Size Excel formula

Closed
mszez Posts 1 Registration date Monday February 8, 2016 Status Member Last seen February 8, 2016 - Feb 8, 2016 at 07:10 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2016 at 12:00 PM
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
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 9, 2016 at 12:00 PM
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
0