IF(ISTEXT to ignore formulas

I want to get a count of names from column "E". The names are linked to another sheet so each cell contains the formula for a link (sheet and cell). The list will change with the selection of a date from a dropdown list, so as the date changes the length of the list will change. I tried to use the formula below but that counts all cells in column "E" weather the cell has just a formula or is returning a name.

Please Login or Register  to view this content.

I have also tried COUNT, COUNTA and COUNTIF vairations but they all include all the link formulas as well. I want to exclude a count of formulas and only count names.

Jim O

Try this

=COUNTIF(E:E,"*?")

that won't count "null strings" returned by formulas