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