Contents
Learning Objectives. 5
Course Introduction. 6
The Basics – One Criterion. 7
IF Function. 8
Boolean Logic. 10
SUMPRODUCT Function. 11
SUMIFS Function. 13
Two Criteria. 15
IF Function combined with
AND Function. 15
Nested IF Functions. 17
Boolean Logic. 19
SUMPRODUCT Function. 21
SUMIFS Function. 23
Using the OR Function. 24
Boolean Logic and SUMPRODUCT. 24
Using the OR Function with
the IF Function. 26
Using Nested IF Functions to
Mimic the OR Function. 27
SUMIFS. 29
Using the NOT Function. 31
Boolean Logic and SUMPRODUCT. 31
Using the NOT Function with
the IF Function. 33
SUMIFS. 34
Three Criteria. 36
Three AND Criteria. 36
IF Function. 36
Nested IF Function. 37
Boolean Logic and SUMPRODUCT. 38
Skipping a Step Using
Boolean TRUE and FALSE. 40
SUMIFS Function. 41
Two AND and One OR Criteria. 42
Boolean Logic and SUMPRODUCT
and SUMIFS. 42
IF Function. 45
Nested IF Functions. 46
Two OR and One AND Criteria. 47
Boolean Logic and SUMPRODUCT
and SUMIFS. 48
IF Function. 51
Nested IF Functions. 52
Case Studies. 54
Case Study 1. 54
Boolean Logic and SUMPRODUCT
and SUMIFS. 54
Boolean Logic with
Multiplication. 56
IF Function. 57
Nested IF Functions. 58
Case Study 2. 58
Boolean Logic and SUMPRODUCT
and SUMIFS. 59
Boolean Logic with
Multiplication. 61
IF Function. 62
Nested IF Functions. 63
Conclusion. 64
Review Questions. 65
Glossary. 66
Index. 67
Exam Questions. 68
Answers to Review Questions. 70