compare two colums and return a result from a third

Hi all,

What I need to do is compare two columns from two different sheets and return the number of match occurances.

For example If sheet one has the value Mary in A2 I need to search all of sheet two for every time mary occurs in a column and return a number result into a separate column.

I know this has to be super basic, but I can't figure it out Also if there is no match I need it to return a 0

TIA!!!

Alright, I have progressed some on my own, but it's still not working the way I need it to...

Here is some screen shots to help and a copy of the formula I'm using:

=IF(AND('BH COMPLAINT - CALL CENTER COMP'!S:S>='Call Center - All'!$E$2, 'BH COMPLAINT - CALL CENTER COMP'!S:S<='Call Center - All'!$E$3),COUNTIF('BH COMPLAINT - CALL CENTER COMP'!A:A,A4),0)

I have multiple sheets. I'm checking dates now because I want to be able to report weekly/monthly/quarterly I think I got the countif function to work...maybe a pivot table would work better, but I want to be able to pull a report each week, plug it in to sheet BH Complaint and have it pull the numbers for me.