Formulas and Functions,Basic Terms in Excel,VLOOKUP, INDEX, MATCH, RANK, SUMPRODUCT, AVERAGE, SMALL, LARGE, LOOKUP, ROUND, COUNTIFS, SUMIFS, CHOOSE, FIND, SEARCH, DATE, and many more. ... Count cells between dates. ... Count cells between two numbers.