Thread: How do I count sets of cells in two columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
  
Posts: 1,560
Default How do I count sets of cells in two columns?
1 2
a 4
b 2
a 4
c 3
b 4

For the above example, I would like a formula that can count how many times
"a" appears in column 1 with "4" in column 2 of the same row. The output for
this example should be 2
Reply With QuoteReply With Quote