Criteria
Using Criteria in formulas to match certain cells.
Last updated
Was this helpful?
Using Criteria in formulas to match certain cells.
Last updated
Was this helpful?
Some functions, such as SUMIF(), take a criteria parameter that other values are compared to. A criteria value can be a literal value, such as 1, FALSE, "blue", etc. A literal value checks for equality (case-insensitive). However, starting a string with a comparison operator enables more complex criteria:
Symbol
Description
"=blue" or "==blue"
Equal comparison (supports )
"<>blue" or "!=blue"
Not-equal comparison (supports )
"<blue"
Less-than comparison
">blue"
Greater-than comparison
"<=blue"
Less-than-or-equal comparison
">=blue"
Greater-than-or-equal comparison