how to combine multiple conditions with search functions and macro the function

Hi all,

I am finding ways to conduct a search for rows with multiple conditions.

e.g.

2010	cat10	closed	yes
2012	dog20	closed	yes
2010	cat15	closed	yes

I need to find 2010,cat,closed, yes as my conditions. Do note that cat has cat10 and cat15, but I want to search anything with cat. so effectively, I will have 2 rows with that condition.

my method:

=SUM(IF(ISERROR(SEARCH("cat",frmAdministratorRecordView'!$AE$2:$AE$25550,1)),0,(IF(frmAdministratorRecordView!AD2:AD25550="yes",IF(frmAdministratorRecordView!AF2:AF25550="2010",IF(frmAdministratorRecordView!L2:L25550="closed",1,0))))

but there is some errors, can somebody guide me along?

I am thinking of seperating the functions so that macro can work, but not sure how.