Completed
Initial Remarks min mark
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SUMIFS Function - Adding with Criteria and SUMIF Function
Automatically move to the next video in the Classroom when playback concludes
- 1 Initial Remarks min mark
- 2 Defined Names min mark
- 3 Ex 1: Add w 1 condition. min mark
- 4 Data Validation List feature min mark
- 5 Ex 2: Add w 2 criteria. min mark
- 6 Ex3: Add w 3 criteria. min mark
- 7 Ex 4: Greater than min mark
- 8 Ex 5: Greater than or equal to min mark
- 9 Ex 6: Less than min mark
- 10 Ex 7: Less than or equal to min mark
- 11 Ex 8: Equal min mark
- 12 Ex 9: Not min mark
- 13 Ex 10: SUMIF if criteria & sum range are same: Saves Typing. min mark
- 14 Ex 11: Add w Comparative Operator - Criteria in Cell. min mark
- 15 Ex 12: Add w Comparative Operator - Criteria NOT in Cell. min mark
- 16 Ex 13: Add w 3 criteria, including "ALL" min mark
- 17 Ex 14: Contains Criteria Partial Text Match or Fuzzy Match. min mark
- 18 Ex 15: Any Customer with exactly 2 characters. min mark
- 19 Ex 16: Criteria typed DIRECTLY into formula often times this is inefficient. min mark
- 20 Ex 17: SUMIFS copied down a column. min mark
- 21 Ex 18: SUMIFS copied down a column and across rows Mixed Cell References copied to whole table. min mark
- 22 Ex 19: Sum Between Two Numbers Lower Included, Upper Not. min mark
- 23 Ex 20: Sum Between Two Dates Inclusive. min mark
- 24 Ex 21: Sum Cells with Corresponding Empty Cells. min mark
- 25 Ex 22: Sum w/ Corr. Empty Cells or Null Text String. min mark
- 26 Ex 23: Sum w/ Corr. NOT Empty Cells. Add when there is text, numbers, Null Text String. min mark
- 27 Ex 24: Sum w/ Corr. NOT Empty Cells or NOT Null Text String. min mark
- 28 Ex 25: Wildcard as Character: Use "~"& to tell SUMIFS to look for * min mark
- 29 Ex 26: Criteria for SUMIFS is not case sensitive. min mark
- 30 Ex 27: Case Sensitive: Use EXACT inside SUMPRODUCT. min mark
- 31 Ex 28: SUMIFS that looks to a different sheet. min mark
- 32 Ex 29: SUMIFS Can't Handle 3_D Cell References. min mark
- 33 Ex 30: SUMIFS to add from multiple columns across multiple sheets using INDIRECT and SUMPRODUCT functions. min mark
- 34 Ex 31: SUMIFS to add from multiple columns across multiple sheets using Sheet Reference and SUMIFS functions on each sheet. min mark
- 35 Ex 32: SUMIFS will not read external references when the workbook is closed. min mark
- 36 Ex 33: Solutions for SUMIFS with external references: SUMPRODUCT or Formula in External Workbook and Workbook Reference. min mark
- 37 Ex 34: SUMIFS with Year Criteria Mismatched against Serial Numbers. min mark 1 hour 57 seconds
- 38 Ex 35: SUMIFS with Month As Text Criteria Mismatched against Serial Numbers. min mark 1 hour 3 minutes 48 seconds
- 39 Ex 36: SUMIF with only 1 cell in sum_range is volatile. min mark 1 hour, 7 minutes 53 seconds
