Главная
Study mode:
on
1
min) Boolean Logic.
2
min) AND criteria = Multiplication = All Logical Test Must Be TRUE.
3
min) SUMPRODUCT can do AND Criteria.
4
min) COUNTIFS, SUMIFS, AVERAGEIFS &
5
min) How IF function calculates AND Criteria for array calculations:
6
min) AND Can Have 2 Or More Logical Tests.
7
min) OR Criteria = Adding = At Least 1 Logical Test Must Be TRUE.
8
min) Boolean Adding for OR Criteria when result can be 2 or more.
9
min) SUMPRODUCT with Boolean Adding for OR Criteria when result can be 2 or more.
10
min) Formula goal: Count transactions that have 'Seattle' or 'Pro2'. But no 'double counting'.
11
min) Calculating notes for Array Formula: =SUMPRODUCT(--(((B76:B80=F77)+(C76:C80=F79)) Greater Than 0)).
12
min) IF function logical_test argument with Boolean Adding for OR Criteria when result can be 2 or more.
13
min) Formula goal: Find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold.
14
min) Could we use DMAX to find max sale for transaction that was in 'Seattle' or where 'Pro2' was sold?
15
min) Calculation Summary for: =MAX(IF((B133:B137=F134)+(C133:C137=G134),D76:D80))
16
min) OR Criteria When There Can Never Be 2 TRUEs
17
min) Four Formulas for Counting with Mutually Exclusive OR Criteria.
18
min) MATCH function with range of values (array) in lookup_value argument.
19
min) Any math operation converts TRUEs and FALEs to 1s and 0s.
20
min) Timing Different Ways of Converting TRUEs and FALSEs to 1s and 0s.
21
min) AND and OR Criteria guidelines.
Description:
Dive into advanced Excel array formulas with this comprehensive 27-minute tutorial focusing on Boolean logic, AND & OR criteria, and converting TRUE/FALSE values. Learn how to use SUMPRODUCT for AND criteria, implement OR criteria using Boolean addition, and efficiently convert logical values to numbers. Master complex formulas for counting transactions, finding maximum sales, and handling mutually exclusive OR criteria. Explore the MATCH function with array lookup values and compare different methods for converting logical values. Gain practical insights into array formula efficiency and guidelines for using AND and OR criteria in Excel calculations.

Ctrl - Shift - Enter - Excel Array Formulas - Boolean Logic, AND & OR Criteria, Convert TRUE FALSE

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Spreadsheets #MATCH function #AVERAGEIFS #COUNTIFS
0:00 / 0:00
1 of 21

min) Boolean Logic.