Excel: Condensing and Counting

[MADavis]

On the left is a table documenting individual plants of a single species (B) in different plots.  There is also a Type designation for each plot.  I would like to create a new table which lists each plot just once along with the number of plants found in each plot and the Type designation for the plot.  Suggestions?

PLOT	SPECIES	TYPE		MASTERID	NO. B	VEG88
8	B	3		8	2	3
8	B	3		10	2	2
10	B	2		11	3	4
10	B	2		13	5	3
11	B	4		14	3	2
11	B	4		15	1	1
11	B	4
13	B	3
13	B	3
13	B	3
13	B	3
13	B	3
14	B	2
14	B	2
14	B	2
15	B	1

[#2 · Accepted solution]

@MADavis That could be SUMIF and VLOOKUP as in the attached file.

[#3]

@MADavis 

PivotTable will work, especially if TYPE are numbers.

[#4]

Thanks, very much.

[#5]

Thanks very much, especially for the VLOOKUP suggestion. This worked great on my 10,000 row file.