Supported Spreadsheet Functions
Pebble Stream currently supports these spreadsheet functions. If you do not see a function you need here, don't hesitate to contact Pebble Stream support.
https://exceljet.net/functions/averageifs-function## ABS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
AND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
AVERAGE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
AVERAGEIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
BASE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
BITAND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING.MATH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CEILING.PRECISE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CHOOSE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COMBIN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COMBINA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
CONCATENATE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
CORREL
v1.0.0+
COUNT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTBLANK
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
COUNTIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DATE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DATEDIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAY
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAYS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DAYS360
Microsoft Documentation
ExcelJet documentation
v1.0.0+
DECIMAL
Microsoft Documentation
ExcelJet documentation
v2.0.0+
DDB
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EDATE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
EFFECT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EVEN
Microsoft Documentation
ExcelJet documentation
v2.0.0+
EXACT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
EXP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FACT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FACTDOUBLE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FALSE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
FIND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR.MATH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FLOOR.PRECISE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
FV
Microsoft Documentation
ExcelJet documentation
v1.0.0+
GCD
Microsoft Documentation
ExcelJet documentation
v1.0.0+
HLOOKUP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFERROR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFNA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INDEX
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
INTERCEPT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
IPMT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISBLANK
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISERR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISERROR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISEVEN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISLOGICAL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNA
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNONTEXT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISNUMBER
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISODD
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISREF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ISTEXT
Microsoft Documentation
ExcelJet documentation
v2.0.0+
LARGE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
LEFT
Microsoft Documentation
ExcelJet documentation
v2.0.0+
LEN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
LOG
Microsoft Documentation
ExcelJet documentation
v2.0.0+
LOWER
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MATCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MAX
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MAXIFS
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MEDIAN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MID
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MIN
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MINIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MOD
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MODE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MODE.SNGL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
MONTH
Microsoft Documentation
ExcelJet documentation
v2.0.0+
MROUND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
N
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NA
Microsoft Documentation
ExcelJet documentation
v2.0.0+
NOMINAL
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NOT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
NOW
Microsoft Documentation
ExcelJet documentation
v2.0.0+
NPER
Microsoft Documentation
ExcelJet documentation
v2.0.0+
NPV
Microsoft Documentation
ExcelJet documentation
v2.0.0+
NUMBERVALUE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
OFFSET
Microsoft Documentation
ExcelJet documentation
v1.0.0+
OR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
PMT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
POWER
Microsoft Documentation
ExcelJet documentation
v1.0.0+
PPMT
Microsoft Documentation
ExcelJet documentation
v2.0.0+
PROPER
Microsoft Documentation
ExcelJet documentation
v2.0.0+
PV
Microsoft Documentation
ExcelJet documentation
v2.0.0+
QUARTILE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
QUARTILE.EXC
Microsoft Documentation
ExcelJet documentation
v2.0.0+
QUARTILE.INC
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RAND
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RANDBETWEEN
Microsoft Documentation
ExcelJet documentation
v2.0.0+
RANK.EQ
Microsoft Documentation
ExcelJet documentation
v2.0.0+
REPLACE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
RIGHT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ROUND
Microsoft Documentation
ExcelJet documentation
v2.0.0+
ROUNDDOWN
Microsoft Documentation
ExcelJet documentation
v2.0.0+
ROUNDUP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
ROW
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SEARCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SIGN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SLOPE
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SQRT
Microsoft Documentation
ExcelJet documentation
v2.0.0+
SUBSTITUTE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
STDEV
Microsoft Documentation
ExcelJet documentation
v2.0.0+
STDEV.P
Microsoft Documentation
ExcelJet documentation=
v2.0.0+
STDEV.S
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUM
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMIF
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMIFS
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMPRODUCT
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMSQ
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMX2MY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMX2PY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SUMXMY2
Microsoft Documentation
ExcelJet documentation
v1.0.0+
SWITCH
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TEXTJOIN
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TRIM
Microsoft Documentation
ExcelJet documentation
v1.0.0+
TRUE
Microsoft Documentation
ExcelJet documentation
v2.0.0+
UPPER
Microsoft Documentation
ExcelJet documentation
v2.0.0+
VAR
Microsoft Documentation
ExcelJet documentation
v2.0.0+
VAR.P
Microsoft Documentation
ExcelJet documentation
v2.0.0+
VAR.S
Microsoft Documentation
ExcelJet documentation
v2.0.0+
VDB
Microsoft Documentation
ExcelJet documentation
v1.0.0+
VLOOKUP
Microsoft Documentation
ExcelJet documentation
v1.0.0+
WEEKDAY
Microsoft Documentation
ExcelJet documentation
v2.0.0+
XNPV
Microsoft Documentation
ExcelJet documentation
v1.0.0+
XOR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
YEAR
Microsoft Documentation
ExcelJet documentation
v1.0.0+
YEARFRAC
Microsoft Documentation
ExcelJet documentation
v1.0.0+
Updated about 1 month ago