Calculations With OR Criteria: COUNTIFS, DCOUNTA, SUMIFS, DSUM

Topics: AND and OR Criteria. Important Functions like: SUMIFS, IF, AND, OR, and more…

Topics in this video:
1. OR Criteria (00:12 min)
2. OR Criteria for counting with 2 COUNTIFS (00:55 min)
3. OR Criteria that does counts and yields incorrect answer (don’t double count) (03:40 min)
4. OR Criteria for counting with DCOUNTA (04:30 min)
5. OR Criteria for adding with 2 SUMIFS (06:49 min)
6. OR Criteria for adding with DSUM (08:23 min)
7. Many OR Criteria adding, long method where you helper cells to make intermediate steps (10:10 min)
8. Many OR Criteria adding: DSUM function (10:43 min)
9. Many OR Criteria adding: SUMIFS and a function argument array operation and the SUMPRODUCT function (12:57 min)
10. Many Or Criteria for a proper data set: DCOUNTA for counting and DSUM for adding (17:26 min)
11. OR and AND Criteria for a adding in Cross Tabulated Table: SUMIFS, a function argument array operation, the SUMPRODUCT function and Mixed Cell References (19:06 min)