Count if contains formula

[messin31]

Im trying to create a formula which says if the cell in column a contains one of a few words, count the cell in column b if the value is less than 11. Here is what I have so far (not working):

=COUNTIF('SEO Positions Report '!B16:B1048576,{"*cat*";"*dog*";"*lizard*"},<11,'SEO Positions Report'!G:G,)

 

[barry houdini]

Try this version

=SUM(COUNTIF('SEO Positions Report '!B:B,{"*cat*";"*dog*";"*lizard*"},'SEO Positions Report'!G:G,"<11"))

Note that it'll double count if one cell contains both "cat" and "dog" for instance......