I have an excel document that has one sheet that is formulated to pull student names from the other sheet. If the student scores do not add up to be greater than the value, it won't list there names and will, instead, leave it blank. I want to create a column that counts any cell that has a student name and is not blank, but I can't do a countif formula because every cell has a formula in it. How do I get it to count only the cells that display names and not the formula?
Solved by C. C. in 15 mins