Count based on two criteria.

[MJKelly]

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

 

[Bob Umlas]

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

 

[MJKelly]

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

Works a treat,

thanks loads,
Matt