Maybe something like this:

Priority 1
=SUMPRODUCT(--(B2:B10=1),--(C2:C10="ACME"))
=SUMPRODUCT(--(B2:B10=1),--(C2:C10="JONES"))

Priority 2
=SUMPRODUCT(--(B2:B10=2),--(C2:C10="ACME"))
=SUMPRODUCT(--(B2:B10=2),--(C2:C10="JONES"))

HTH,
Paul

--

"excelnewbie" wrote in message
...
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