Aggregate Formulas = Formulas that do the math for you скачать в хорошем качестве

Aggregate Formulas = Formulas that do the math for you

Aggregate formulas are the foundation of spreadsheets and everyone should be fluent with them. They can go from super basic to fairly advanced. You'd be surprised how much each formula comes up in the real world so the more you know, the better. This is a foundations lesson showing how to do count, counta, countif, countifs, sum, sumif, sumifs, average, averageif, averageifs, median, medianif, and how to make the formulas dynamic. These are crucial to any analysis and will give you a good understanding of a ton of things you can do in your spreadsheet. 00:00 - Intro 00:49 - Count Formulas 03:48 - Sum Formulas 05:40 - Average Formulas 07:27 - Median Formulas 08:48 - Dynamic Formulas