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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2016 at 12:00 PM
Related:
- Formula for excel
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel apk for pc - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Feb 9, 2016 at 12:00 PM
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
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