Highline Excel 2013 Class Video 10

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

DESCRIPTION

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.

WORKBOOKS

Download “Highline Excel 2013 Workbooks” Highline-Excel-2013-Video-Workbooks.zip – Downloaded 105 times – 21 MB




Be the first to comment

Leave a Reply