Another function, COUNT (), counts the cells in its range that contain numbers. Many of Excel's statistical functions also calculate the aggregate value of a range of cells.

Figure A After adding the MIN () function, you’re ready to add a conditional format rule. Follow these steps. 1. Select the data range. In this case, that’s B2:E4. 2.

Some of the most common aggregate functions in Excel are SUM, AVERAGE, MIN, MAX, and COUNT. These functions can take one or more arguments, such as a range of cells or a criteria.

Similarly, you can perform various other functions such as Average, Count, Min, Max, and so on, depending on your requirements. I hope you found this basic tutorial useful.

In this tutorial, you’ll learn what a timestamp is and then how to use Excel functions MIN () and MAX () to return the first and last call for the day from timestamps.