Various Count Functions in Excel. If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how ...

For example, if you want to search all cells from A1 to J55 for the phrase "monthly report," you would type this function: .=COUNTIF (A1:J55,"monthly report"). Note that the phrase is not case ...

In Microsoft Excel, you are not just able to count characters in a single/multiple cell, but also specific characters in a cell or range of cells.

I also used the term function earlier in this section. The word “sum” in the formulas used in these examples is one of Excel’s many functions. In this case, the sum function is used to add ...

If you wish to count the same or duplicate values in a column only once in Excel or the count of occurances of duplicate values, read this article.