In a spreadsheet, a type of formula used to represent something that may be too complex or too long to expect an ordinary user to enter, or used for common tasks like adding the numbers in one column, e.g. SUM(A1:A15) adds all the values in cells A1 to A15.