Alphabetical - S

SCAN	(Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.
SEARCH	The starting position of a substring within a larger text string.
SEC	(2013) The secant of a number.
SECH	(2013) The hyperbolic secant of a number.
SECOND	The number of seconds as an integer given a date serial number.
SEQUENCE	(2021) The array of sequential numbers.
SERIESSUM	The sum of a power series based on a formula.
SHEET	(2013) The sheet number of the referenced sheet.
SHEETS	(2013) The number of sheets in a reference.
SIGN	The numerical value indicating if a number is positive or negative.
SIN	The sine of a number.
SINGLE	(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SINH	The hyperbolic sine of a number.
SKEW	The number representing the skewness of a distribution based on a sample.
SKEW.P	(2013) The number representing the skewness of a distribution based on an entire population.
SLN	The depreciation of an asset in a single period (straight-line method).
SLOPE	The slope of a linear regression line through the given data points.
SMALL	The kth smallest value in a list or array of numbers.
SORT	(2021) The array of data in a range that has been sorted by one column.
SORTBY	(2021) The array of data in a range that has been sorted based on multiple columns or values in a range.
SQRT	The positive square root of a number.
SQRTPI	The square root of a number multiplied by PI.
STANDARDIZE	The normalized value from a distributed characterised by a mean and a standard deviation.
STDEV	(STDEV.S) The standard deviation based on a sample.
STDEV.P	The standard deviation based on an entire population.
STDEV.S	The standard deviation based on a sample.
STDEVA	The standard deviation based on a sample (including logical values and text).
STDEVP	(STDEV.P) The standard deviation based on an entire population.
STDEVPA	The standard deviation based on an entire population (including logical values and text).
STEYX	The standard error of a regression.
STOCKHISTORY	(Microsoft 365) The historical data about a financial instrument.
SUBSTITUTE	The text string after replacing instances of a substring.
SUBTOTAL	(AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUM	The total of the values in a list, range or array.
SUMIF	(SUMIFS) The total of the values that satisfies one condition.
SUMIFS	The total of the values that satisfies multiple conditions.
SUMPRODUCT	The sum of the product of one or more arrays of values.
SUMSQ	The sum of the squares of all the values in a list, table or cell range.
SUMX2MY2	The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2	The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2	The sum of squares of differences of corresponding values in two arrays.
SWITCH	(2019) The value based on a list of exact matches.
SYD	The depreciation of an asset in a single period (sum-of-years digits method).

SCAN (Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.
SEARCH The starting position of a substring within a larger text string.
SEC (2013) The secant of a number.
SECH (2013) The hyperbolic secant of a number.
SECOND The number of seconds as an integer given a date serial number.
SEQUENCE (2021) The array of sequential numbers.
SERIESSUM The sum of a power series based on a formula.
SHEET (2013) The sheet number of the referenced sheet.
SHEETS (2013) The number of sheets in a reference.
SIGN The numerical value indicating if a number is positive or negative.
SIN The sine of a number.
SINGLE (2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column.
SINH The hyperbolic sine of a number.
SKEW The number representing the skewness of a distribution based on a sample.
SKEW.P (2013) The number representing the skewness of a distribution based on an entire population.
SLN The depreciation of an asset in a single period (straight-line method).
SLOPE The slope of a linear regression line through the given data points.
SMALL The kth smallest value in a list or array of numbers.
SORT (2021) The array of data in a range that has been sorted by one column.
SORTBY (2021) The array of data in a range that has been sorted based on multiple columns or values in a range.
SQRT The positive square root of a number.
SQRTPI The square root of a number multiplied by PI.
STANDARDIZE The normalized value from a distributed characterised by a mean and a standard deviation.
STDEV (STDEV.S) The standard deviation based on a sample.
STDEV.P The standard deviation based on an entire population.
STDEV.S The standard deviation based on a sample.
STDEVA The standard deviation based on a sample (including logical values and text).
STDEVP (STDEV.P) The standard deviation based on an entire population.
STDEVPA The standard deviation based on an entire population (including logical values and text).
STEYX The standard error of a regression.
STOCKHISTORY (Microsoft 365) The historical data about a financial instrument.
SUBSTITUTE The text string after replacing instances of a substring.
SUBTOTAL (AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUM The total of the values in a list, range or array.
SUMIF (SUMIFS) The total of the values that satisfies one condition.
SUMIFS The total of the values that satisfies multiple conditions.
SUMPRODUCT The sum of the product of one or more arrays of values.
SUMSQ The sum of the squares of all the values in a list, table or cell range.
SUMX2MY2 The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2 The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2 The sum of squares of differences of corresponding values in two arrays.
SWITCH (2019) The value based on a list of exact matches.
SYD The depreciation of an asset in a single period (sum-of-years digits method).