SUMIFS & COUNTIFS: 4 Types of Criteria: Cell Reference, Hard Code, Operator Joined, Array
Download Excel File: https://ift.tt/2jXe8yh
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
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