Aggregate formulas are the foundation of spreadsheets and everyone should be fluent with them. They can go from super basic to fairly advanced. Youd be surprised how much each formula comes up 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, meadian, medianif, and how to make the formulas dynamic. Theae are crucial to any analysis and will give you a good understanding of a ton o