Summing Functions
Worksheet Functions
| AGGREGATE | Returns the aggregate of values in a list, table or cell range. |
| SUBTOTAL | Returns the subtotal of values in a list, table or cell range. |
| SUM | Returns the total of the values in a list, table or cell range. |
| SUMIF | Returns the total of the values that satisfies one condition. |
| SUMIFS | Returns the total of the values that satisfies multiple conditions. |
| SUMPRODUCT | Returns the sum of the product of one or more arrays of values. |
| DEVSQ | Returns the sum of the squared deviations from the mean. |
| DSUM | Returns the total of the values in a column that satisfies multiple conditions. |
| AGGREGATE Returns the aggregate of values in a list, table or cell range. |
| SUBTOTAL Returns the subtotal of values in a list, table or cell range. |
| SUM Returns the total of the values in a list, table or cell range. |
| SUMIF Returns the total of the values that satisfies one condition. |
| SUMIFS Returns the total of the values that satisfies multiple conditions. |
| SUMPRODUCT Returns the sum of the product of one or more arrays of values. |
| DEVSQ Returns the sum of the squared deviations from the mean. |
| DSUM Returns the total of the values in a column that satisfies multiple conditions. |
Conditional Summing
| SUMIF | Using the SUMIF function with multiple conditions. |
| SUMIFS | Using the SUMIFS function with multiple conditions. |
| SUMPRODUCT | Using the SUMPRODUCT function with multiple conditions. |
| {SUM} | Using the SUM function with array formulas. |
| SUMIF Using the SUMIF function with multiple conditions. |
| SUMIFS Using the SUMIFS function with multiple conditions. |
| SUMPRODUCT Using the SUMPRODUCT function with multiple conditions. |
| {SUM} Using the SUM function with array formulas. |
User Defined Functions
| SUMDIGITS | Returns the sum of the digits in a cell. |
| SUMFORMAT_CELLCOLOR | Returns the sum of all the values that have been formatted with a particular colour. |
| SUMFORMAT_FONTBOLD | Returns the sum of all the values that have been formatted in bold. |
| SUMFORMAT_FONTCOLOR | Returns the sum of all the values that have been formatted with a particular font. |
| SUMVISIBLE | Returns the total value of the numbers in cells that are visible. |
| SUMVISIBLEIFS | Returns the total value of the numbers that satisfies multiple conditions in cells that are visible. |
| SUMDIGITS Returns the sum of the digits in a cell. |
| SUMFORMAT_CELLCOLOR Returns the sum of all the values that have been formatted with a particular colour. |
| SUMFORMAT_FONTBOLD Returns the sum of all the values that have been formatted in bold. |
| SUMFORMAT_FONTCOLOR Returns the sum of all the values that have been formatted with a particular font. |
| SUMVISIBLE Returns the total value of the numbers in cells that are visible. |
| SUMVISIBLEIFS Returns the total value of the numbers that satisfies multiple conditions in cells that are visible. |
More Summing Formulas
Summing Formulas contains a list of all summing related formulas.
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext