Forum Discussion
COUNTA and ISBLANK
Have the data been imported/copied from a source outside Excel? The blank-looking cells are not really blank.
One workaround is to use
=COUNTIF(Table3_1[@[Text Between Delimiters.5]:[Text Between Delimiters.11]], "> ")
Another is to select the entire table except for the last column, then activate the Visual Basic Editor (Alt+F11), activate the Immediate window (Ctrl+G), type
Selection.Value = Selection.Value
and press Enter. The COUNTA formula will then work correctly.
anupambit1797 It counts values that are "larger" (alphabetically) than a space " ". A space is the first ordinary character in the sort order.
Thank you so muchHansVogelaar , earlier I studied # and $, but this "> " was new for me.. sorry for my short skill on Excel, but what we call such special "> " functions in excel, is there any link say where I can find the list of all such special functions using these > ,< #,$ etc.. with their definition( like what they do; can be used to do?)
Br,
Anupam
> is not a function but an operator. See for example Calculation operators and precedence in Excel
$ is used to make a cell reference absolute. See Switch between relative, absolute, and mixed references
# is relatively new - it refers to the spill range of a dynamic array formula. See Spilled range operator