Download Excel File: https://excelisfun.net/files/EMT1647.xlsx
See different formulas for calculating a sum, a count and an average when you have an OR Logical Test with many conditions or criteria. See how to calculate a Sum, Count and Average for Team Sales Numbers. Here are the formulas you will learn about:
1. (00:01) Introduction
2. (00:28) What is an OR Logical Test?
3. (00:44) Adding Team Sales using SUMPRODUCT & SUMIFS and a Function Argument Array Operation.
4. (02:30) Learning about Problem when copying formula with Fill Handle and Cross Hair / Angry Rabbit Cursor. Copying using keyboards.
5. (03:24) Counting Team Sales using SUMPRODUCT & COUNTIFS and a Function Argument Array Operation.
6. (03:49) Keyboard for Fill Right: Ctrl + R.
7. (03:58) Average Teams Sales with Simple Division.
8. (04:15) Average Team Sales using AVERAGE, IF and TRANSPOSE functions.
9. (05:36) Average Team Sales using AVERAGE, FILTER, ISNUMBER and XMATCH Functions..
10. (07:25) Summary and End Video Links