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.