{"id":81,"date":"2024-05-01T08:54:34","date_gmt":"2024-05-01T08:54:34","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-5-count-min-and-max-functions\/"},"modified":"2024-09-18T00:52:20","modified_gmt":"2024-09-18T00:52:20","slug":"chapter-5-count-min-and-max-functions","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-5-count-min-and-max-functions\/","title":{"raw":"Chapter 5: COUNT, MIN and MAX Functions","rendered":"Chapter 5: COUNT, MIN and MAX Functions"},"content":{"raw":"
\r\n
\r\n

Learning Objectives<\/p>\r\n\r\n<\/header>\r\n

\r\n
    \r\n \t
  1. Use the COUNT function.<\/li>\r\n \t
  2. Use the MIN function.<\/li>\r\n \t
  3. Use the MAX function.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<\/div>\r\n

    In this chapter, you will learn another three popular functions in Excel, the [pb_glossary id=\"184\"]COUNT[\/pb_glossary], [pb_glossary id=\"188\"]MIN [\/pb_glossary]and [pb_glossary id=\"186\"]MAX[\/pb_glossary] functions.<\/p>\r\n

    The COUNT Function<\/strong><\/p>\r\n

    Let\u2019s learn the COUNT function.<\/p>\r\n

    Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.<\/p>\r\n

    The Figure below shows another an example using the COUNT function.<\/p>\r\n

    \"image\"<\/p>\r\n

    Figure 5.1 Type the formula using the COUNT function.<\/p>\r\n

    Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =COUNT(B2:B6) in cell E2. Press Enter and you get the result. Excel returns 3 as the result as there are values in cells B2, B3, and B5. Blank cells and those with text are not counted.<\/p>\r\n

    That's all for the COUNT function.<\/p>\r\n

    The MIN and MAX Functions<\/strong><\/p>\r\n

    Now let\u2019s learn the MIN and MAX functions.<\/p>\r\n

    The MIN function finds the smallest numeric value in a range of cells, while the MAX function helps you find the largest numeric value in a range of cells.<\/p>\r\n

    The Figure below shows the use of the MIN and MAX functions.<\/p>\r\n

    \"image\"<\/p>\r\n

    Figure 5.2 Type the formula using the MIN function.<\/p>\r\n

    Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =MIN(B2:B6) in cell F2. Press Enter and you get the result. Excel returns 5 as the result as it is the lowest value in the range of cells.<\/p>\r\n

    In the same worksheet, use the MAX function. See the Figure below.<\/p>\r\n

    \"image\"<\/p>\r\n

    Figure 5.3 Type the formula using the MIN function.<\/p>\r\n

    Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =MAX(B2:B6) in cell F3. Press Enter and you get the result. Excel returns 27 as the result as it is the highest value in the range of cells.<\/p>\r\n

    That\u2019s all for this Chapter.<\/p>\r\n

    You're awesome!<\/p>\r\n\r\n<\/div>","rendered":"

    \n
    \n
    \n

    Learning Objectives<\/p>\n<\/header>\n

    \n
      \n
    1. Use the COUNT function.<\/li>\n
    2. Use the MIN function.<\/li>\n
    3. Use the MAX function.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

      In this chapter, you will learn another three popular functions in Excel, the COUNT<\/a>, MIN <\/a>and MAX<\/a> functions.<\/p>\n

      The COUNT Function<\/strong><\/p>\n

      Let\u2019s learn the COUNT function.<\/p>\n

      Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.<\/p>\n

      The Figure below shows another an example using the COUNT function.<\/p>\n

      \"image\"<\/p>\n

      Figure 5.1 Type the formula using the COUNT function.<\/p>\n

      Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =COUNT(B2:B6) in cell E2. Press Enter and you get the result. Excel returns 3 as the result as there are values in cells B2, B3, and B5. Blank cells and those with text are not counted.<\/p>\n

      That’s all for the COUNT function.<\/p>\n

      The MIN and MAX Functions<\/strong><\/p>\n

      Now let\u2019s learn the MIN and MAX functions.<\/p>\n

      The MIN function finds the smallest numeric value in a range of cells, while the MAX function helps you find the largest numeric value in a range of cells.<\/p>\n

      The Figure below shows the use of the MIN and MAX functions.<\/p>\n

      \"image\"<\/p>\n

      Figure 5.2 Type the formula using the MIN function.<\/p>\n

      Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =MIN(B2:B6) in cell F2. Press Enter and you get the result. Excel returns 5 as the result as it is the lowest value in the range of cells.<\/p>\n

      In the same worksheet, use the MAX function. See the Figure below.<\/p>\n

      \"image\"<\/p>\n

      Figure 5.3 Type the formula using the MIN function.<\/p>\n

      Type the contents in their respective cells. Use the default font and font size. Adjust any column width if necessary. Then, type =MAX(B2:B6) in cell F3. Press Enter and you get the result. Excel returns 27 as the result as it is the highest value in the range of cells.<\/p>\n

      That\u2019s all for this Chapter.<\/p>\n

      You’re awesome!<\/p>\n<\/div>\n

      definition<\/span>