Completed
Ex 31: SUMIFS to add from multiple columns across multiple sheets using Sheet Reference and SUMIFS functions on each sheet. 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
