Formula Query - COUNTIF? Column A contains word and Column B contains word

Originally Posted by daffodil11

=COUNTIFS(A1:A5000,2013,B1:B5000,"*John Smith*")

* = Wildcard value. In this expression is means anything+"John Smith"+anything. It would even count John Smith in "djfjohn smith132srs"

Thanks for the response - This worked great. If only the function was recognised in Google Spreadsheets! I'll just have to export the data to Excel. (Company's decision to use all things Google)