COUNT – Counts the number of cells that contain only numbers except for blank cells. COUNTA – Counts the number of cells which contains alpha-numeric except blank cells. Q9)Is it possible to make a single Pivot Table for multiple data sources? Yes, it is possible. Using the Pivot Table Data Modeling technique.