How to count cells containing text in Google Sheets To count cells containing text in Google Sheets, we will use 2 functions in Google Sheets: COUNTA and COUNTIF.