Excel Array Formula Series #7: Boolean Logic & Criteria

Description

See how to create array formulas for Summing and Counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions. In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions....