COUNTIF, COUNTIFS Function

[ZoeToro]

Hello!
I am developing a dashboard and on the summary tab I am trying to create a table summary with data similar to the below.
For SUV, I need to count all the instances Tundra shows up, select all available options (Doors-4, 4-Door, etc), and also AWD, 4WD. I have tried using the COUNTIFS and I am getting zero.
Any help will be greatly appreciated:

Data:
[TABLE="width: 507"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD][/TD]
[TD]Model[/TD]
[TD]Specification: 4-Door, Hatchback, Doors-4, Power window[/TD]
[TD="colspan: 2"]Drive Train[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tundra[/TD]
[TD]4-Door[/TD]
[TD]AWD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Camry[/TD]
[TD]Hatchback[/TD]
[TD]AWD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Avalon[/TD]
[TD]Doors-4[/TD]
[TD]4WD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Taurus[/TD]
[TD]4-Door[/TD]
[TD]4WD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]GTR[/TD]
[TD]3-Door[/TD]
[TD]AWD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Eclipse[/TD]
[TD]2-Door[/TD]
[TD]2WD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tundra[/TD]
[TD]Doors-4[/TD]
[TD]4WD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Camry[/TD]
[TD]Doors-4[/TD]
[TD]4WD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Avalon[/TD]
[TD]Doors-4[/TD]
[TD]AWD[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Summary Table:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Type[/TD]
[TD]Specification: 4-Door, Hatchback, Doors-4, Power window[/TD]
[TD]AWD[/TD]
[TD]4WD[/TD]
[TD]2WD[/TD]
[/TR]
[TR]
[TD]Sports car[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SUV[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CUV[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sedan[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Truck


[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[MartyS]

Without a link between the two tables, it's difficult to create a formula/code to do what you want.

For example, looking at it "manually".. I don't know which model comes under "Sports car", which comes under "SUV" and which comes under "CUV".

Without knowing how to reference the data, its impossible to match it up.


Also.. can I just check the summary table does what you want it to do?

Let's say you've got a Tundra (SUV) that has 2-door, 2WD and another record that says Tundra (SUV) 4-door, 4WD.

Summarising that data would show: SUV: 2-door, 4-door, 2WD (yes) and 4WD (yes)

From the summarised data, you wouldn't be able to tell that there aren't records for a [4-door 2WD] or a [2-door 4WD]

(Same thing happens each time there is a category with more than one model in it)