Performs a specified calculation (e.g. the sum, product, average, etc.) for a supplied set of values.
Returns the number of cells in a column or database that contains numeric values and meets a given criteria.
Counts the cells which contain number only.
List of Functions SUM Function Count Function CountA Function LEN Function TRIM Function RIGHT, LEFT and MID Function VLOOKUP IF Statements SUMIF, COUNTIF AND AVERAGEIF CONCATENATE Function 1. SUM Function The SUM function allows you to add 2 or more numbers together. Sum function can be directly applied to sets of number separated by comma, […]