Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

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 ...

This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Using Excel's COUNTIFS () function, you can quickly count records that fall between two dates.

You can use the Row function in Excel formulas to access the row number of any particular cell. For example, Row (B5) will give you the numeric result "5" and Row (A1) will give you the number "1".

For the previous articles, see How to use Excel’s conditional formatting to compare lists. The example data Let’s take a quick look at a simple example.