View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MJKelly MJKelly is offline
external usenet poster
 
Posts: 114
Default 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