Exclude blanks in COUNTIF referencing another cell

[Zoelarae]

I have a formula that is counting everytime a referenced cell's text appears in another worksheet. It is working perfectly so far for what I need currently. But I want to continue the formula down the column in blank rows so that if I add another team member later, it will still work. When I do that, it counts all the blank cells. This is my current formula:

=(COUNTIF(Sunday!A:B,"*"&A3&"*"))

and here is a section of my table for reference:

Team Member	SUN	SUN	%%%%
	Turns	Sales	CLOSE
SS	4	0	0.00%
SCR	0	0	0.00%
CB	6	0	0.00%
MI	0	0	0.00%
SW	5	0	0.00%
EW	2	0	0.00%
DF	2	0	0.00%
KH	0	0	0.00%
			0.00%
			0.00%
			0.00%
			0.00%
Store Total	19	0	0.00%

<tbody>
</tbody>

I am down to the wire on my deadline for this and am running in circles

 

[Jonmo1]

Try

=IF(A3="","",COUNTIF(Sunday!A:B,"*"&A3&"*"))

 

[Zoelarae]

IT WORKED!!!

Thank you!

 

[Jonmo1]

You're welcome.