Category - Statistical
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. |
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext