Excel function - COUNTA is used to get the total count of Any-value or Non-Blanks in range. COUNTA Function has one required and optional argument: value1, value2