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. This function is useful when you need to get the sum of rows that have been filtered using the AutoFilter.
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. This function is useful when you need to get the sum of rows that have been filtered using the AutoFilter.

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

SUMVISIBLEReturns the total value of the numbers in cells that are visible.
SUMIFVISIBLEReturns the total value of the numbers that satisifies one condition in cells that are visible.
SUMIFSVISIBLEReturns the total value of the numbers that satisfies multiple conditions in cells that are visible.
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.
SUMDIGITSReturns the sum of the digits in a cell.
SUMVISIBLE
Returns the total value of the numbers in cells that are visible.
SUMIFVISIBLE
Returns the total value of the numbers that satisifies one condition in cells that are visible.
SUMIFSVISIBLE
Returns the total value of the numbers that satisfies multiple conditions in cells that are visible.
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.
SUMDIGITS
Returns the sum of the digits in a cell.

More Summing Formulas

Summing Formulas contains a list of all summing related formulas.



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