Count totals based on one tab's columns, in same spreadsheet, to another tab

[tubells]

I have an inventory list in TAB A and in TAB B based on a model, I want to do an auto count.

Eg. TAB A

Name Model
aaa A1
bbb B3
ccc A1
ddd C4
eee A1
fff B3


Now in Tab B, I have a list of all Models and I want to have a formula that calculates (based on count in TAB A) the total number of the said models. So need a formula for the Model column in Tab B

Eg. Model Count
A1 3
B3 2
C4 1
D5 0

Appreciate any help on this.
Thanks

[The_Snook]

Hi tubells,

A COUNTIF formula should cover what you need (see attached example).

Regards,

Snook

[tubells]

Thanks Snook for the quick response. I see the logic, but somehow it does not seem to work. I have to check my syntax again. Just wanted to ack. your response for now.

[tubells]

Hi Snook,

I found out my error. I had created the TAB B based on a count and had copied and pasted it line by line to this tab. It had a 'COUNT' at the end - which i did a replace all with blank. To the ***** eye it looked the same but it is not. I now copied my exact model from TAB A and put it in my TAB B and I get the correct count.

Thank you very much and wish you a very good day / evening!. May Liverpool always win in football!

[The_Snook]

You're welcome mate, I'm happy to help (and thanks for the rep).

Up the Red men indeed!

Snook