Hello,

I need some help with the following:

I require cell K3 (in worksheet named 'brokers') to count the number of
times the data in A3 matches those in mar!B:B.
I have acheived this by using formula: =COUNTIF(mar!B:B,Brokers!A:A)

However, i now need to insert another arguement, where in addition to the
above, only count if mar!M:M contains the letter 'y'.

Please help,

Thanks

Aaron