Thread: COUNTIF for 2 columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ziggy Ziggy is offline
external usenet poster
  
Posts: 47
Default COUNTIF for 2 columns
Another 2003 solution is an array formula

=SUM(($K$15:$K$38=K41)*($M$15:$M$38=1))

Set with CTRL-Shift-Enter
Reply With QuoteReply With Quote