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
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 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

1 reply

TrowaD
Posts
2884
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 21, 2022
512
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