I want to count the number of cells in a column that have visible values. I tried the COUNTA function, but that function is counting all my cells, even the blank ones. This is because the blank cells contain formula that make them blank. I can paste as text, but I need the formulas to run while the Count function operates. How can I accomplish this?