Thread: Concatenation in a CountIf
View Single Post
  #5   Report Post  
 
Posts: n/a
Default Concatenation in a CountIf
Have a look at INDIRECT

eg. =COUNTIF(INDIRECT("K13:K"&A4),"1")

hth RES
Reply With QuoteReply With Quote