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

Microsoft Documentation

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+