Count based on two criteria.
 

Hi,

How do I get a summary of a table of data according to two criteria?
I want to check instances of "A" in one column and then where "A" is
found, check that "B' occurs in the same row, but a different column.
I'm not counting numeric values here, just the instances where A and B
occur in the same row on the table.

Hope I've explained myself?
Matt

Count based on two criteria.
 

=SUMPRODUCT(N(A1:A100="A"),N(B1:B100="B"))
or if using Excel 2007:
=COUNTIFS(A1:A00,"A",B1:B100,"B")

"MJKelly" wrote in message
...
Hi,

How do I get a summary of a table of data according to two criteria?
I want to check instances of "A" in one column and then where "A" is
found, check that "B' occurs in the same row, but a different column.
I'm not counting numeric values here, just the instances where A and B
occur in the same row on the table.

Hope I've explained myself?
Matt

Count based on two criteria.
 

On May 15, 9:31*pm, "Bob Umlas" wrote:
=SUMPRODUCT(N(A1:A100="A"),N(B1:B100="B"))
or if using Excel 2007:
=COUNTIFS(A1:A00,"A",B1:B100,"B")

"MJKelly" wrote in message

...

Hi,

How do I get a summary of a table of data according to two criteria?
I want to check instances of "A" in one column and then where "A" is
found, check that "B' occurs in the same row, but a different column.
I'm not counting numeric values here, just the instances where A and B
occur in the same row on the table.

Hope I've explained myself?
Matt

Works a treat,

thanks loads,
Matt