Hi, I want to count the number of nonblank cells in a column. The problem is if I just use COUNTA(), then it also counts those blank texts (e.g., ""). As we know, COUNTA() counts those that are exactly blank (no contents at all). If a cell, say A1, has a blank text "", then it is counted in. I just want to exclude those cells with blank texts, and only count those with real values.
Thanks a lot for your great advice.
Bookmarks