Small | Medium | Large | |
Blue | 1 | 1 | 2 |
Red | 1 | ||
Green | 2 | ||
Orange | 1 | ||
Purple | 1 | 2 | |
Yellow | 2 | 1 | 1 |
<tbody>
</tbody>
So I need six different cells to have formulas counting all of the different combinations. First cell would be a formula to show the number of Small and Dark combinations. Second cell would show Medium and Dark, etc. It seems like it should be straightforward but I'm struggling to come up with the right formula. I feel like it needs a sumproduct, but I just can't get it to work. I would really appreciate anyone's help. Also, data is not sorted in any particular order and would need to stay that way. Thanks in advance!!