Alphabetical - S

SCAN	(2024) 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 (not case sensitive).
SEC	The secant of a number.
SECH	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	The sheet number of the referenced sheet.
SHEETS	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	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 numerical value.
SORT	(2021) The array of data that has been sorted by one column.
SORTBY	(2021) The array of data that has been sorted based on multiple columns.
SQL.REQUEST	(Removed in 2003) The result after connecting to a data source and executes a SQL query.
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	(2024) The historical data about a financial instrument.
SUBSTITUTE	The text string after replacing instances of a substring.
SUBTOTAL	(AGGREGATE) The choice of 11 different operations for numerical values (renamed).
SUM	The total of the numerical values.
SUMIF	(SUMIFS) The total of the numerical values that satisfies one condition.
SUMIFS	The total of the numerical values that satisfies multiple conditions.
SUMPRODUCT	The sum of the product of one or more arrays of values.
SUMSQ	The variation of a data set from its mean.
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 (2024) 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 (not case sensitive).
SEC The secant of a number.
SECH 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 The sheet number of the referenced sheet.
SHEETS 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 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 numerical value.
SORT (2021) The array of data that has been sorted by one column.
SORTBY (2021) The array of data that has been sorted based on multiple columns.
SQL.REQUEST (Removed in 2003) The result after connecting to a data source and executes a SQL query.
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 (2024) The historical data about a financial instrument.
SUBSTITUTE The text string after replacing instances of a substring.
SUBTOTAL (AGGREGATE) The choice of 11 different operations for numerical values (renamed).
SUM The total of the numerical values.
SUMIF (SUMIFS) The total of the numerical values that satisfies one condition.
SUMIFS The total of the numerical values that satisfies multiple conditions.
SUMPRODUCT The sum of the product of one or more arrays of values.
SUMSQ The variation of a data set from its mean.
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).