Need help counting sizes per shirt color

[rodge_3210]

Hello and thanks in advance for the help.

I am trying to count the number of sizes per shirt color. I have been looking for ways to utilize the COUNTIF/COUNTIFS function, but can't seem to make it work. Here's the layout:

Column A is the sizes-YL to AXL (A1:A03)
Column B is the color of the shirt-black, gray, white, etc. A total of 5 colors. (B1:B103)

These will be teams, so each color has multiple sizes. I need help with a formula that will count the unique sizes per color of the shirt. Any help?[table="width: 500"]

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[rodge_3210]

Thank you. It's been posted.

[kvsrinivasamurthy]

In D2

Please Login or Register  to view this content.

In E2

Please Login or Register  to view this content.

In F2

Please Login or Register  to view this content.

Copy down all

[AliGW]

I don't see where you have mocked up an idea of what you are trying to do.

[rodge_3210]

Thank you for the help. I posted an example file based on the instructions. Attached is the full file with all of the shirts (total of 103).

Can you update the attached? I tried, but I'm afraid I'm causing more issues.

[AliGW]

You may have missed post #4 above mine.

[rodge_3210]

I'm sorry. It's shown in the first tab.

[rodge_3210]

I was able to make it work. Thanks for the help! This was exactly what I needed.

[kvsrinivasamurthy]

Pl see file with formulas.