View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ingeman ingeman is offline
external usenet poster
 
Posts: 2
Default Using Countif on multiple columns

Why doesn't the following formula work? =count(if(k2:k20,"1",j2:j20,"<40"))