Excel Forum

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.

Got a Question? Ask it Here in the Forum.