[header] How to count cells with text in excel on pc or mac [title] Open the excel file you want to edit on your computer. [step] You can open microsoft excel and find your file on the saved spreadsheets list, or just double-click the file to open it. [title] Click an empty cell. 
[step] Find an empty cell to insert your counting formula, and click it. [title] Type = countif (range, criteria) in the empty cell.