MIN, MAX and COUNT

Once you know =SUM(range) you know the shape of most of Excel. MIN gives the smallest number in a range, MAX the largest, and COUNT how many of the cells hold a number at all.

COUNT is the odd one out, and usefully so: it counts numbers, not entries. If it returns fewer than you expect, some of your numbers are text, which is a free diagnostic you can run on any column.