If you have a large table of this type of data you should learn how to use
PIVOT TABLES, this will give the output you are looking for.

"excelnewbie" wrote:

I have a spreadsheet that looks like this:

Defect Priority Vendor
bug1 1 ACME
bug2 1 JONES
bug3 2 ACME
bug4 1 ACME

I need to be able to summarize the number of bugs for each vendor by priority.

Prirority 1 Priority 2
ACME: 2 ACME: 1
JONES: 1 JONESs: 0

I can't seem to find a function that will let me do it.
--
gm