Excel Magic Trick 1467: Count Open Projects by Day and Project Code, Including Empty Cells
Download Files: http://ift.tt/2xWBRR3
Entire page with all Excel Files for All Videos: http://ift.tt/1kSFWvs
Learn about how to Count Open Projects by Day and Project Code, Including Empty Cells with the following Complex Criteria: 1) Start Date Less Than or Equal To Date AND 2) Start Date NOT Empty Cell AND 3) End Date Great Than Or Equal To Date OR End Date = Empty Cell AND 4) Project Code = Project Code. Learn about COUNTIFS and SUMPRODUCT functions and the elements that go into each function when there is comp-lex Criteria. Also learn about what the syntax is for “Not Empty Cell” and “Empty Cell” in the COUNTIFS function. Further, learn how to have both an AND Logical Test and an OR Logical Test in the SUMPRODUCT function and the COUNTIFS Function.
Topics:
1. (00:11) Introduction
2. (03:35) SUMPRODUCT Function Formula.
3. (13:03) Two COUNTIFS Functions Formula
4. (20:14) SUMPRODUCT & COUNTIFS functions in same formula, with a Function Argument Array Operation in the COUNTIFS.
5. (25:36) Summary
Reference Videos:
Excel Magic Trick 784: Empty Cells OR Formula Created Blank: Confusion Over Word “Blank”
Excel Magic Trick 972: Empty Cell or Null Text String in Formulas: Counting Formulas
Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
Excel 2013 Statistical Analysis #27: Adding Law of Probability for OR Events (12 Examples)
https://www.youtube.com/watch?v=1y8kpjZYicg