Excel Formula To Count Text In A Cell. Copy and paste the formula count a1 d15 into the formula bar then press the enter key. Select a blank cell for putting the counting result.
Press ctrl c to copy cell b2 then select cells b3 and b4 and then press ctrl v to paste its formula into cells b3 b4. Sumproduct istext a2 a20 when you enter it it will return the number of cells that contain text. After counting the cell number with text this section will show you the formula of counting the cell number with number.
Press ctrl c to copy cell b2 then select cells b3 and b4 and then press ctrl v to paste its formula into cells b3 b4.
To count the number of cells with text in them you can also create a formula by combining sumproduct and istext. Sumproduct istext a2 a20 when you enter it it will return the number of cells that contain text. Select a blank cell for putting the counting result. Copy and paste the formula count a1 d15 into the formula bar then press the enter key.
