Thread: Using Countif on multiple columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default Using Countif on multiple columns
"ingeman" wrote in message
...
Why doesn't the following formula work?
=count(if(k2:k20,"1",j2:j20,"<40"))

Try this:

=SUMPRODUCT(--(K2:K20=1),--(J2:J20<40))

Biff


Reply With QuoteReply With Quote