Try using the following formula.

=IF(Sheet1!A1:A3=Sheet2!A1,COUNTIF(Sheet1!B1:B3,"x "),"")

Be sure to enter the correct sheet name and range.

"ignitedaz" wrote:

I'm trying to think of a formula to compare two cells together once they
match I need to count how many times another cell has an entry in it. Any
ideas?? For example one sheet has initials, and the other sheet has those
initials in it. Once it sees those initials it will count how many times
that other cell has an "X" in it.