SUMIF( )
Sample Usage:SUMIF($C$8:$C$17,">=50")
Sintax: SUMIF(range, criterion)
Applying Criteria (with relational operators)
Cells greater than 75: ">75"
Cells equal to 100: "100"
Cells less than or equal to 100: "<=100"
Cells equal to "Red":"red"
Cells not equal to "Red":"<>red"
Cells that are blank " ": " "
Cells that are not blank:"<>"
Cells that begin with "X": "x*"
Cells less than A1: "<"&A1"
Cells less than today: "<"&TODAY()
SUMIF( )
Sample Usage: SUMIF($J$5:$J$16,J19,$K$5:$K$16)
Sintax: SUMIF(range, criterion, [sum_range])
SUMIF( )
(Case sensitive)
Sample Usage: SUMIF(ARRAYFORMULA(REGEXMATCH($F$47,$E$34:$E$44)),true,G34:G44)
Sintax: SUMIF(range, criterion, [sum_range])
SUMIF( )
(Case sensitive)
Sample Usage: SUMIF(ARRAYFORMULA(REGEXMATCH($F$47,$E$34:$E$44)),true,G34:G44)
Sintax: SUMIF(range, criterion, [sum_range])
SUMIF( )
Partial matches with wildcards
COUNT( )
Sample Usage: COUNT(C5:C11)
​
SintaxCOUNT(value1, [value2, ...])
​Note:
-
COUNT counts all numeric values in a dataset, including those which appear more than once. To count unique values, use COUNTUNIQUE.
​
-
COUNT counts only numeric values; text values are ignored."
COUNTA( )
Sample Usage: COUNTA(C23:C29)
Sintax: COUNTA(value1, [value2, ...])
Note:
-
COUNTA counts both text and numeric values.
-
COUNTA will count:
-
Numbers
-
Dates
-
Formulas
-
Logical expressions
-
Errors, e.g. #DIV/0!
-
Textual data
-
Cells containing
-
COUNTIF( )
Sample Usage: COUNTIF($C$40:$C$46,"<100")
Sintax: COUNTIF(range, criterion)
Note:
-
COUNTIF can only perform conditional counts with a single criterion. To use multiple criteria, use COUNTIFS or the database functions DCOUNT or DCOUNTA.
-
COUNTIF is not case sensitive."
COUNTIF( )
with partial matches
Sample Usage: =COUNTIF($B$58:$B$65,"*"&B68&"*")
Sample Usage: =COUNTIF($B$58:$B$65,B69)
Note: There are two ways of using wildcards with COUNTIF: You can either concatenate cells with wildcards. For example: ""*""&B67&""*"" or entering the matching text in between asterisks directly in the cell.
For example: *apples*.
COUNTIF( )
with partial matches and case sensitive
Sample Usage =COUNTIF(ARRAYFORMULA(REGEXMATCH(B58:B66,B76)), true)
COUNTIFS( )​
Sample Usage: =COUNTIFS(C93:C101,"Apartment",D93:D101,"Buyer")
​
Sintax: =COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
