Download workbook: people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm
Topics in this video:
1. OR Criteria (00:12 min)
2. OR Criteria for counting with 2 COUNTIFS (00:55 min)
3. OR Criteria that does counts and yields incorrect answer (don't double count) (03:40 min)
4. OR Criteria for counting with DCOUNTA (04:30 min)
5. OR Criteria for adding with 2 SUMIFS (06:49 min)
6. OR Criteria for adding with DSUM (08:23 min)
7. Many OR Criteria adding, long method where you helper cells to make intermediate steps (10:10 min)
8. Many OR Criteria adding: DSUM function (10:43 min)
9. Many OR Criteria adding: SUMIFS and a function argument array operation and the SUMPRODUCT function (12:57 min)
10. Many Or Criteria for a proper data set: DCOUNTA for counting and DSUM for adding (17:26 min)
11. OR and AND Criteria for a adding in Cross Tabulated Table: SUMIFS, a function argument array operation, the SUMPRODUCT function and Mixed Cell References (19:06 min)
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. It contains 50 video lectures teaching the basics of Excel, as well as advanced concepts.
Be sure to download the workbook to follow along with the examples. They are found on the official course website.