4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too

SUMIFS & COUNTIFS: 4 Types of Criteria: Cell Reference, Hard Code, Operator Joined, Array
Download Excel File: https://excelisfun.net/files/EMT1563-1564.xlsx
Entire page with all Excel Files for All Videos: http://people.highline.edu/mgirvin/excelisfun.htm
In this video
Topics:
1. (00:01) Intro
2. (00:32) Cell Reference as Criteria for SUMIFS
3. (01:22) Hard Coded Value as Criteria for COUNTIFS
4. (01:43) Excel’s Golden Rule
5. (02:28) Cell Reference Joined To Comparative Operator as Criteria in COUNTIFS, See an AND Logical Test
6. (04:29) Array Criteria (Function Argument Array Operation) as Criteria for SUMIFS, see and OR Logical Test and the SUMPRODUCT Function
7. (06:16) Conclusion

Видео 4 Types of Criteria for SUMIFS & COUNTIFS - Excel Magic Trick 1564, SUMIF & COUNTIF too канала ExcelIsFun