Highline Excel 2013 Class Video 10

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

TOPICS IN THIS VIDEO

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