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