MIN(range); =MAX(range) where range equals the list of numbers you’re calculating. Common uses of this function are; for example, find the highest/lowest grade in a classroom; the highest/lowest ...

The real power here is that you can substitute MAX() with just about any Excel function. For example, Figure B shows the sum of columns D and E. I changed the array reference from [Date ...

Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples: =MAX(B4:B13) returns the highest value in the list. =MIN(B4:B13) returns the lowest value ...