### Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntax

Learn that comparative operators for COUNTIF and SUMIFS functions must be text and have double quotes , but logical formulas (TRUE FALSE) do not require double quotes and are not considered text.

Length:
08:21