Completed
) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations.
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Conditional Calculations with Excel Formulas - Comprehensive Lessons
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) AND Logical Test (AND Criteria)
- 3 ) AND Function
- 4 ) SUMIFS, COUNTIFS, AVERAGEIFS functions with AND Criteria
- 5 ) Create Names From Selection
- 6 ) Cross Tabulated Table for adding with 3 criteria: SUMIFS and Mixed Cell References.
- 7 ) Between Logical Tests, Create Monthly Sales Report with SUMIFS.
- 8 ) Create Monthly Sales Report with SUMIFS and EOMONTH functions.
- 9 ) Count Sales Between Upper and Lower Limit (Frequency Table) with COUNTIFS (Alos consider how this method is different from FREQUENCY Array Function).
- 10 ) D Functions (Database functions) with AND Criteria
- 11 ) Array Formulas with AND Criteria. Use Two IF Functions. See how to calculate Standard Deviation with two conditions or criteria.
- 12 ) OR Logical Test (OR Criteria)
- 13 ) Defined Names and Scope in an Excel Workbook
- 14 ) OR Function
- 15 ) OR Criteria looking at one column using SUMIFS and SUMPRODUCT for adding and COUNTIFS and SUMPRODUCT for counting. Function Argument Array Operations.
- 16 ) Average calculation with OR Criteria: AVERAGE & Array Formula (for 1 or more columns)
- 17 ) D Functions (Database functions) with OR Criteria
- 18 ) AND and OR and IF Functions for Credit Analysis for Accounts Receivable Department
- 19 ) IF Function & IS functions. Bank Checkbook Example.
- 20 ) Conditional Calculations: PivotTable or Formulas?
- 21 ) Summary
