CountA - using two columns of data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excelnewbie - 29 May 2008 21:13 GMT

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.

Signature

Reply to this Message

PCLIVE - 29 May 2008 21:21 GMT

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

>I have a spreadsheet that looks like this:
>
[quoted text clipped - 12 lines]
>
> I can't seem to find a function that will let me do it.

Reply to this Message

willy - 30 May 2008 01:59 GMT

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.

> I have a spreadsheet that looks like this:
>
[quoted text clipped - 11 lines]
>
> I can't seem to find a function that will let me do it.

Reply to this Message