Category - Statistical

List of user defined functions

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.

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.