Statistical Functions

List of user defined functions

AVERAGEIFReturns the average value of cells that satisfies one condition.
AVERAGEIFVISIBLEReturns the average of the visible non blank cells that satisfies one condition.
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.
AVERAGEVISIBLE 
MAXIFReturns the largest value in a range of values that match a certain condition.
MAXIFVISIBLEReturns the largest of the visible non blank cells that satisfies one condition.
MAXIFSVISIBLEReturns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIFReturns the middle value in a range of values that satisfies one condition.
MEDIANIFVISIBLEReturns the middle value from the visible non blank cells that satisfies one condition.
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.
MINIFReturns the smallest value in a range of values that satisfies one condition.
MINIFVISIBLEReturns the smallest of the visible non blank cells that satisfies one condition.
MINIFSVISIBLEReturns the smallest of the visible non blank cells that satisfies multiple condition.
AVERAGEIF
Returns the average value of cells that satisfies one condition.
AVERAGEIFVISIBLE
Returns the average of the visible non blank cells that satisfies one condition.
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
MAXIF
Returns the largest value in a range of values that match a certain condition.
MAXIFVISIBLE
Returns the largest of the visible non blank cells that satisfies one condition.
MAXIFSVISIBLE
Returns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIF
Returns the middle value in a range of values that satisfies one condition.
MEDIANIFVISIBLE
Returns the middle value from the visible non blank cells that satisfies one condition.
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.
MINIF
Returns the smallest value in a range of values that satisfies one condition.
MINIFVISIBLE
Returns the smallest of the visible non blank cells that satisfies one condition.
MINIFSVISIBLE
Returns the smallest of the visible non blank cells that satisfies multiple condition.

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