Help Center
Homepage
Formula
Formula
Formulas(71)
GroupBy(3)
GROUPBY
DATETIME
UNION
Function(10)
SUMIF
COUNTIF
MAXIF
MINIF
QUARTILEIF
STDEVS
STDEVSIF
IF
MAX
MIN
Relation(6)
XLOOKUP
CRYPTMD5
JSON.SELECT
VALUEAT
FIND
SUBMIT
Number(10)
CALC
ADD
CEIL
FLOOR
MOD
POWER
DINT
SUM
COUNT
MATH.BIT
Datetime(15)
DATE
DATEFORMAT
TIMESTAMPTODATE
DATEDIF
DAY
DAYS
DAYS360
HOUR
ISOWEEKNUM
DAYOFWEEK
MINUTE
MONTH
SECOND
TIME
YEAR
String(27)
ASC
CHAR
CLEAN
CODE
CONCAT
CONTAINS
DBCS
EXACT
FINDB
FIXED
LEFT
LEN
LOWER
MID
PICK
PROPER
REPLACE
REPLACEALL
REPT
RIGHT
SEARCH
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER
VALUETOTEXT
Website
open in new window
< Contents
#
All data processing formulas
Formulas(71)
GroupBy(3)
GROUPBY
DATETIME
UNION
Function(10)
SUMIF
COUNTIF
MAXIF
MINIF
QUARTILEIF
STDEVS
STDEVSIF
IF
MAX
MIN
Relation(6)
XLOOKUP
CRYPTMD5
JSON.SELECT
VALUEAT
FIND
SUBMIT
Number(10)
CALC
ADD
CEIL
FLOOR
MOD
POWER
DINT
SUM
COUNT
MATH.BIT
Datetime(15)
DATE
DATEFORMAT
TIMESTAMPTODATE
DATEDIF
DAY
DAYS
DAYS360
HOUR
ISOWEEKNUM
DAYOFWEEK
MINUTE
MONTH
SECOND
TIME
YEAR
String(27)
ASC
CHAR
CLEAN
CODE
CONCAT
CONTAINS
DBCS
EXACT
FINDB
FIXED
LEFT
LEN
LOWER
MID
PICK
PROPER
REPLACE
REPLACEALL
REPT
RIGHT
SEARCH
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER
VALUETOTEXT
✉️ Ask Tablize
How to count data