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:
[TABLE="width: 319"]
<tbody>[TR]
[TD]Team Member[/TD]
[TD]SUN[/TD]
[TD]SUN[/TD]
[TD]%%%%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Turns[/TD]
[TD]Sales[/TD]
[TD]CLOSE[/TD]
[/TR]
[TR]
[TD]SS[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]SCR[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]MI[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]SW[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]EW[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]DF[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]KH[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]Store Total[/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
</tbody>[/TABLE]
I am down to the wire on my deadline for this and am running in circles
=(COUNTIF(Sunday!A:B,"*"&A3&"*"))
and here is a section of my table for reference:
[TABLE="width: 319"]
<tbody>[TR]
[TD]Team Member[/TD]
[TD]SUN[/TD]
[TD]SUN[/TD]
[TD]%%%%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Turns[/TD]
[TD]Sales[/TD]
[TD]CLOSE[/TD]
[/TR]
[TR]
[TD]SS[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]SCR[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]MI[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]SW[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]EW[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]DF[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]KH[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]0.00%[/TD]
[/TR]
[TR]
[TD]Store Total[/TD]
[TD]19[/TD]
[TD]0[/TD]
[TD]0.00%[/TD]
[/TR]
</tbody>[/TABLE]
I am down to the wire on my deadline for this and am running in circles