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.