How to use formulae or formula in this case?
 

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.

How to use formulae or formula in this case?
 

hi
If I sure what your mean, write manufacturer list in E2,... and try this
formula in F2,...
=SUMIF(A2:A13,"witty wings",C2:C13) and etc...for other manufacturers.
for total of results try:
=SUM(F2:F8)
hopes this helps

"Cheng Joo" wrote:

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.

How to use formulae or formula in this case?
 

@ nader:

Thanks! Helped me a whole lot! =D I'm not very proficient at Excel for
starters..haha..


"nader" wrote:

hi
If I sure what your mean, write manufacturer list in E2,... and try this
formula in F2,...
=SUMIF(A2:A13,"witty wings",C2:C13) and etc...for other manufacturers.
for total of results try:
=SUM(F2:F8)
hopes this helps