Thread: How do I COUNTIF in excel using multiple criteria?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DJ_Swammi
 
Posts: n/a
Default How do I COUNTIF in excel using multiple criteria?
I am trying to set up a function which looks to see if multiple criteria,
across different columns are met.

Idealy I should think the following function should work, but alas, it does
not:

=COUNTIF(AND(A1:A5=1, B1:B5=2))

Any suggestions?
Reply With QuoteReply With Quote