COUNT() Calculates the count of items identified inside the parentheses. =COUNT(LEFT) The number of values to the left of the formula cell, in the same row. DEFINED() Evaluates whether the argument inside the parentheses is defined. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.