Summing Functions

List of user defined functions

SUMFORMATReturns the sum of all the values that have been formatted with a particular colour.
SUMFORMAT_CELLCOLOR 
SUMFORMAT_FONTBOLD 
SUMFORMAT_FONTCOLOR 
SUMDIGITSReturns the sum of the digits in a cell.
SUMVISIBLEReturns the sum of visible non blank cells.
SUMIFVISIBLEReturns the sum of visible non blank cells that satisfies one condition.
SUMIFSVISIBLEReturns the sum of visible non blank cells that satisfies multiple conditions.
SUMFORMAT
Returns the sum of all the values that have been formatted with a particular colour.
SUMFORMAT_CELLCOLOR
SUMFORMAT_FONTBOLD
SUMFORMAT_FONTCOLOR
SUMDIGITS
Returns the sum of the digits in a cell.
SUMVISIBLE
Returns the sum of visible non blank cells.
SUMIFVISIBLE
Returns the sum of visible non blank cells that satisfies one condition.
SUMIFSVISIBLE
Returns the sum of visible non blank cells that satisfies multiple conditions.

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