Summing Functions


Worksheet Functions

SUMReturns the total value of the numbers in a list, table or cell range.
SUMIFReturns the total value of the numbers that satisifies one condition.
SUMIFSReturns the total value of the numbers that satisfies multiple conditions.
SUMPRODUCTReturns the sum of the product of one or more arrays of values.
AGGREGATEReturns the aggregate of values in a list, table or cell range.
SUM
Returns the total value of the numbers in a list, table or cell range.
SUMIF
Returns the total value of the numbers that satisifies one condition.
SUMIFS
Returns the total value of the numbers that satisfies multiple conditions.
SUMPRODUCT
Returns the sum of the product of one or more arrays of values.
AGGREGATE
Returns the aggregate of values in a list, table or cell range.

Conditional Summing

SUMIFUsing the SUMIF function with multiple conditions.
SUMIFSUsing the SUMIFS function with multiple conditions.
SUMPRODUCTUsing 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

SUMDIGITSReturns the sum of the digits in a cell.
SUMFORMAT_CELLCOLORReturns the sum of all the values that have been formatted with a particular colour.
SUMFORMAT_FONTBOLDReturns the sum of all the values that have been formatted in bold.
SUMFORMAT_FONTCOLORReturns the sum of all the values that have been formatted with a particular font.
SUMVISIBLEReturns the total value of the numbers in cells that are visible.
SUMVISIBLEIFSReturns 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.



© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext