7 Ara 2019 ... How to Use Excel COUNTIF Text · 1. Select a blank cell. Let's say cell E2 (in our Case) and enter the formula. =COUNTIF(A2:A9,”*Roni Roy*”) into ...