CountA - using two columns of data

E

excelnewbie

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.
 
P

PCLIVE

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
 
W

willy

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.
 
Top