Category - Statistical

List of user defined functions

AVERAGEIFSVISIBLEReturns the average of the visible non blank cells that satisfies multiple condition.
AVERAGETOPReturns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLEReturns the average value from the visible, non blank cells.
COUNTIFSVISIBLEReturns the number of visible non blank cells that satisfies multiple conditions.
COUNTVISIBLEReturns the number of visible non blank cells.
MAXIFSVISIBLEReturns the largest of the visible non blank cells that satisfies multiple condition.
MAXVISIBLEReturns the largest value from the visible, non blank cells.
MEDIANIFSReturns the middle value in a range of values that satisfies multiple conditions.
MEDIANIFSVISIBLEReturns the middle value from visible non blank cells that satisfies multiple conditions.
MEDIANVISIBLEReturns the middle value from the visible cells.
MINIFSVISIBLEReturns the smallest of the visible non blank cells that satisfies multiple condition.
MINVISIBLEReturns the smallest value from the visible, non blank cells.
SUMIFSVISIBLEReturns the sum of visible non blank cells that satisfies multiple conditions.
SUMVISIBLEReturns the sum of visible non blank cells.
AVERAGEIFSVISIBLE
Returns the average of the visible non blank cells that satisfies multiple condition.
AVERAGETOP
Returns the average from a range of values only considering the top "x" values.
AVERAGEVISIBLE
Returns the average value from the visible, non blank cells.
COUNTIFSVISIBLE
Returns the number of visible non blank cells that satisfies multiple conditions.
COUNTVISIBLE
Returns the number of visible non blank cells.
MAXIFSVISIBLE
Returns the largest of the visible non blank cells that satisfies multiple condition.
MAXVISIBLE
Returns the largest value from the visible, non blank cells.
MEDIANIFS
Returns the middle value in a range of values that satisfies multiple conditions.
MEDIANIFSVISIBLE
Returns the middle value from visible non blank cells that satisfies multiple conditions.
MEDIANVISIBLE
Returns the middle value from the visible cells.
MINIFSVISIBLE
Returns the smallest of the visible non blank cells that satisfies multiple condition.
MINVISIBLE
Returns the smallest value from the visible, non blank cells.
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