Work with MAX, MAXIFS, LARGE, and related functions

- [Instructor] Excel has over 100 different…statistical functions.…If you're looking for them in going…to the Formulas tab, initially you don't see…that category here.…But it's listed under More Functions…and there is Statistical.…And as I suggested, quite a few of them,…well over 100 here.…Now some of the most commonly used ones are…Max and Min but there are some others as well, too.…If we want to know what the highest compensation amount is…in this list, we could certainly sort the data,…but we want to keep it in this current order.…It's alphabetized by name.…We don't really need to sort it anyway…but we want to know what the highest compensation amount is.…

Equal max.…And in this example here we're going to click column E…because there's nothing else in column E…except those numbers and the title on top.…If a list like this had interim totals…and a total on the bottom, we'd have to reconsider…your use of this.…It might not work at all if you've got…a lot of totals within it.…The example here, we're all set,…we don't have to type that right parenthesis.…