Column A Column B Column C
Column D

Manufacturer Scale Quantity
Model

Witty Wings 1:72 1 F-15
Witty Wings 1:72 1
F-16
Japanese Kit (Toy) 1:144 1
F-117
Tamiya Kit 1:72 2
AV-8B
Japanese Kit (Toy) 1:144 1
F-16
Xi Fei 1:48 1
Su-27
Tamiya Kit 1:72 1
RAH-66
Hogan 1:200 1
B747
Italeri Kit 1:48 1
EF2000
Maisto 1:144 1
F-16
Tamiya Kit 1:72 1
Skyray
Matchbox 1:144 1
F-16

Total No.: 13

Looking at the above case, using a formula or a combination of formulae in
Column F (in the example below), how can I create a statistics table showing
the number of times a manufacturer appears while still keeping correct count
of the total number of models?

The statistics table should look like this:

Column E Column F

Manufacturer Number
Witty Wings 2
Tamiya Kit 4
. .
. .
. .
. .

TOTAL 13

Sorry for the trouble and thanks in advance for helping me.

Sorry for the mangled formatting..its been altered by the website..