Category - Summing

List of user defined functions

SUMBETWEEN*Returns the sum of values that are between a range.
SUMDIGITS*Returns the sum of the digits in a cell.
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
SUMVISIBLEReturns the sum of visible, non blank cells in a range.
SUMVISIBLEIFSReturns the sum of visible, non blank cells that satisfies multiple conditions.
SUMBETWEEN
*Returns the sum of values that are between a range.
SUMDIGITS
*Returns the sum of the digits in a cell.
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
SUMVISIBLE
Returns the sum of visible, non blank cells in a range.
SUMVISIBLEIFS
Returns the sum of visible, non blank cells that satisfies multiple conditions.

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