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:
<tbody>
</tbody>
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:
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