Category - Summing

List of user defined functions

SUMBETWEENReturns the sum of values that are between a range.
SUMDIGITSReturns 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.
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.
SUMVISIBLEIFS
Returns the sum of visible non blank cells that satisfies multiple conditions.

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