Limit COUNTA fn to cells whose formula returns any text
Posted on 2011-02-25
I have a spreadsheet which contains formulas down column A to pull in names from another spreadsheet column A. I will refer to the other spreadsheet as [other]. Each cell in column A contains an IF statement =if([other]A1="","",[other]A1). The spreadsheet column A looks like:
ROW 1: Name 1
ROW 2: Name 2
ROW 3: Name 3
ROW 4: Name 4
My problem is that at the bottom of column A, I want to count how many names I have, and not include any cells that contain merely the if statement. A normal COUNTA(A1:A6) will return 6 but I need it to return 4.
How do I limit the COUNTA function in this way? Or should I be doing it another way?