Excel Magic Trick 1236

DESCRIPTION

Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT?
Learn how to count numbers that contain the whole number 4:
(00:11) Problem Introduction
(01:05) COUNTIFS formula that uses Cell References, Comparative Operators and the Ampersand (Join Symbol)
(03:14) INT and SUMPRODUCT Array Formula with three array operations. Learn about how Excel calculates formulas. Learn about using Double Negative to convert TRUEs and FALSESs (Boolean Values) to ones and zeroes (1s and 0s).

WORKBOOKS