Counting the number of data To count the number of cells in an Excel data, we use the following function. =COUNT(range) [range] = Select the corresponding range in calculating cell number. Definition of function A function to count the number of cells of a number EXCEL version Excel2003 ・ Excel2007 ・ Excel2010 ・ Excel2013・ Excel2016・・・