Excel Magic Trick 1181

Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT

DESCRIPTION

See how to:
(00:08) Count numbers with 4 or more characters using COUNTIFS function. See that COUNTIFS requires Comparative Operators in Double Quotes.
(02:00) Count text cells that contain 4 or more characters using LEN and SUMPRIDUCT functions, array operations, and see that direct array operations do not require Double Quotes around comparative operators. Also see how double negatives can convert TRUEs and FALSEs (Boolean values) to ones and zeros, 1s and 0s.