function to count cells containing text google sheets

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