Find number of times a value from a list appears in a seperate column

Hi all,



I have a Book with 2 sheets. Sheet2 has a column that has been a list of Payees. Some payees appear numerous times in this column.



I have a list of all the payees i want to search on written in Column A on Sheet1.



I need to find out how many times any name on my list on sheet one appears in the column on sheet2 with the added argument of column A on sheet 2 = RSA.



Example



Sheet1 has the following in column A



Name1

Name2

Name3

Name4

Name5



Sheet 2 has the following in column I



Name1

Name1

Name2

Name3

Name2

Name4

Name5



I have already managed to get the formula to tell me how many times the names appear on the list, but i need to add the following rule to the formula.



Current Formula: =COUNTIF(Sheet2!I:I,Sheet1!A:A) this returns me every time a name on my list appears in the column on sheet2



I need to add the following argument.



Count the times that a name on my list appears in column I on sheet 2 if column A on sheet 2 also = RSA



Many Thanks

Thank you, this worked!