Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS скачать в хорошем качестве

Highline Excel 2013 Class Video 10: AND & BETWEEN Criteria: SUMIFS, DSUM, COUNTIFS, AVERAGEIFS

Download workbook: http://people.highline.edu/mgirvin/Al... This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. 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)