Summing Functions

List of user defined functions

SUMFORMATReturns the sum of all the values that have been formatted with a particular colour.
SUMFORMAT_CELLCOLORReturns the total value of the numbers that have been formatted with the same colour.
SUMFORMAT_FONTBOLDReturns the sum of all the values that have been formatted in bold.
SUMFORMAT_FONTCOLORReturns the total value of the numbers that have been formatted with the same font colour
SUMDIGITSReturns the sum of the digits in a cell.
SUMIFSVISIBLEReturns the sum of visible non blank cells that satisfies multiple conditions.
SUMVISIBLEReturns the sum of visible non blank cells.
SUMFORMAT
Returns the sum of all the values that have been formatted with a particular colour.
SUMFORMAT_CELLCOLOR
Returns the total value of the numbers that have been formatted with the same colour.
SUMFORMAT_FONTBOLD
Returns the sum of all the values that have been formatted in bold.
SUMFORMAT_FONTCOLOR
Returns the total value of the numbers that have been formatted with the same font colour
SUMDIGITS
Returns the sum of the digits in a cell.
SUMIFSVISIBLE
Returns the sum of visible non blank cells that satisfies multiple conditions.
SUMVISIBLE
Returns the sum of visible non blank cells.

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