CountA - using two columns of data
 

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

CountA - using two columns of data
 

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

CountA - using two columns of data
 

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