If you want to count the frequency of a text in Excel, you can use the Countif function. This article explains the step-by-step procedure.

To determine how many clients the tax department services in this dataset, we will use the function COUNTIF. This is because we want to count the number of times the word “Tax” is listed under the ...

Let’s use the above-mentioned formula to count nonblank cells in different cell ranges, like I3:I8 and F2:F8. In this case, the formula will become: =COUNTA(I3:I8,F2:F8) Hit Enter when you are done.