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
|