So...I'm trying to use COUNTIF to count all cells with text data in a column formatted as text. I've used the formula COUNTIF($A:$A,"*") to accomplish this. Works fine if I type the data in. But much of the data is pasted from another source (using paste values). The COUNTIF formula will NOT consider any pasted data.
For the simple formula, I could convert from COUNTIF to COUNTA, but this won't work for my two variable formulas (COUNTIFS).
What gives? Any ideas? I need the cells to be text format to ensure that the leading zeros are not just showing, but are included in another cell that concatenates that data.
For the simple formula, I could convert from COUNTIF to COUNTA, but this won't work for my two variable formulas (COUNTIFS).
What gives? Any ideas? I need the cells to be text format to ensure that the leading zeros are not just showing, but are included in another cell that concatenates that data.