How to return the last value in an Excel data range Your email has ... COUNTA() evaluates all values, including text and even an empty string, “”. However, it doesn’t count blank cells.