AND & BETWEEN Criteria: SUMIFS, COUNTIFS, AVERAGEIFS, more

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

Topics in this video:
1. AND Criteria for SUMIFS, COUNTIFS, AVERAGEIFS (00:34 min)
2. DSUM (05:18 min)
3. SUMIFS with 3 criteria (07:53 min)
4. Use COUNTIFS or COUNTIF for 1 condition? (10:36 min)
5. Use SUMIFS or SUMTIF for 1 condition? (12:35 min)
6. Between Criteria (Lower and Upper Limits) with comparative operators in Formula Input Cells (17:03 min)
7. Between Criteria with Text Labels and comparative operators joined to cell references in formula (21:43 min)
8. Quarterly Report: Between Criteria for Dates. Between an upper and lower date for each quarter. Comparative operators joined in formula. (28:44 min)
9. EOMONTH function (30:15 min)
10. Compare COUNTIFS formula and PivotTable for Between Criteria with an upper and lower limit (34:13 min)