Microsoft Office Tutorials and References
In Depth Information
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu
• Click the OK button to display the
highest value in the range D4:D12
in cell D15 (Figure 2–21).
Why should I not just enter the
highest value that I see in the
range D4:D12 in cell D15?
In this example, rather than
entering the MAX function,
you easily could scan the
range D4:D12, determine that the
highest number of shares is 990,
and manually enter the number
990 as a constant in cell D15.
Excel would display the number
the same as in Figure 2–21. Because
it contains a constant, however,
Excel will continue to display 990
in cell D15, even if the values in
the range D4:D12 change. If you
use the MAX function, Excel will
recalculate the highest value in
the range D4:D9 each time a new
value is entered into the worksheet.
highest value in
highest value in
1. Click Sum button arrow on
Ribbon, click Max function
2. Click Formulas tab on
Ribbon, click AutoSum
button arrow, click Max
3. Type =MAX in cell
The next step is to enter the MIN function in cell D16 to determine the lowest (minimum) number in the
range D4:D12. Although you can enter the MIN function using either of the methods used to enter the AVERAGE
and MAX functions, the following steps perform an alternative using the Sum button on the Ribbon.
• Select cell D16.
• Click the Sum button arrow on the
Ribbon to display the Sum button
menu (Figure 2–22).
Sum button arrow
Why should I use the Sum
Using the Sum button menu allows
you to enter one of ﬁ ve often-used
functions easily into a cell, without
having to memorize its name or the
Sum button menu
D16 is active cell