Category - Statistical

List of user defined functions

AVERAGEAVISIBLE	Returns the average value from the visible, non blank cells in a range (including logical values and text).
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.
AVERAGEVISIBLEIFS	Returns the average of the visible non blank cells that satisfies multiple condition.
MAXAVISIBLE	Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN	Returns the largest value that is between a range.
MAXVISIBLE	Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS	Returns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIFS	Returns the middle value in a range of values that satisfies multiple conditions.
MEDIANVISIBLE	Returns the middle value from the visible cells.
MEDIANVISIBLEIFS	Returns the middle value from visible non blank cells that satisfies multiple conditions.
MINAVISIBLE	Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN	Returns the smallest value that is between a range.
MINVISIBLE	Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS	Returns the smallest of the visible non blank cells that satisfies multiple condition.
PRODUCTVISIBLE	Returns the product of visible non blank cells.

AVERAGEAVISIBLE Returns the average value from the visible, non blank cells in a range (including logical values and text).
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.
AVERAGEVISIBLEIFS Returns the average of the visible non blank cells that satisfies multiple condition.
MAXAVISIBLE Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN Returns the largest value that is between a range.
MAXVISIBLE Returns the largest value from the visible, non blank cells.
MAXVISIBLEIFS Returns the largest of the visible non blank cells that satisfies multiple condition.
MEDIANIFS Returns the middle value in a range of values that satisfies multiple conditions.
MEDIANVISIBLE Returns the middle value from the visible cells.
MEDIANVISIBLEIFS Returns the middle value from visible non blank cells that satisfies multiple conditions.
MINAVISIBLE Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN Returns the smallest value that is between a range.
MINVISIBLE Returns the smallest value from the visible, non blank cells.
MINVISIBLEIFS Returns the smallest of the visible non blank cells that satisfies multiple condition.
PRODUCTVISIBLE Returns the product of visible non blank cells.