Главная
Study mode:
on
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
Description:
Explore an in-depth tutorial on using the SUMIFS and SUMIF functions in Excel to add with one or more criteria. Learn through 36 practical examples covering various scenarios, from basic single-condition sums to complex multi-criteria calculations across multiple sheets. Master comparative operators, wildcards, case sensitivity, and handling empty cells. Discover techniques for working with dates, external references, and mismatched data types. Gain insights into efficient formula construction, cell referencing, and potential pitfalls. Apply these skills to enhance your data analysis capabilities and streamline your Excel workflows.

SUMIFS Function - Adding with Criteria and SUMIF Function

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Data Manipulation
0:00 / 0:00
1 of 39

Initial Remarks min mark