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"]
Bookmarks