View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin
 
Posts: n/a
Default How Do I use COUNTIF Combining the Text from 2 Columns

I want to do a COUNTIF using the text combine in 2 columns.
I tried using concatenate =COUNTIF(A:A&B:B,"FPP*Conn*") but I get an
formula error