Excel Functions Statistical Functions

List of user defined functions

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.

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.