Can Excel Auto Report Data in a Sheet Based off of Column Headings?

[Yishay23]

I have data in excel broken up by different headers. I want to see if there is a way excel can automatically report volume of this data. Say, how many rows are a under a certain category and label. I currently do this using another excel file and summing but it takes manual input. An example is the table below. What I want is to input a formula into a separate cell or sheet that says under the red label there is 1 animal case and 1 clothes case.

Data:[TABLE="width: 500"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Label[/TD]
[TD]Case Ref[/TD]
[/TR]
[TR]
[TD]Animals[/TD]
[TD]Red[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Cars[/TD]
[TD]Blue[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]Toys[/TD]
[TD]Yellow[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]Clothes[/TD]
[TD]Red[/TD]
[TD]D[/TD]
[/TR]
</tbody>[/TABLE]

Desired Outcome:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Red[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Animals[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Clothes[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]