[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]Small
[/TD]
[TD]Medium
[/TD]
[TD]Large
[/TD]
[/TR]
[TR]
[TD]Blue
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Red
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Green
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Purple
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Yellow
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a worksheet that I need some help with. I need formulas to accomplish a count. Basically I have two columns outside of this range. One column is labeled "Light" and lists underneath it all of the light colors...so Orange, Purple and Yellow. A second column is labeled "Dark" and lists underneath it all of the dark colors...Blue, Red and Green. (Work with me I'm totally making up all of this) What I want to know is how many Light and Dark colors I have in each size.
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!!
<tbody>[TR]
[TD][/TD]
[TD]Small
[/TD]
[TD]Medium
[/TD]
[TD]Large
[/TD]
[/TR]
[TR]
[TD]Blue
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Red
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Green
[/TD]
[TD][/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Purple
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Yellow
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have a worksheet that I need some help with. I need formulas to accomplish a count. Basically I have two columns outside of this range. One column is labeled "Light" and lists underneath it all of the light colors...so Orange, Purple and Yellow. A second column is labeled "Dark" and lists underneath it all of the dark colors...Blue, Red and Green. (Work with me I'm totally making up all of this) What I want to know is how many Light and Dark colors I have in each size.
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!!