Maths Functions
![]() |
| AVERAGEVISIBLE | Returns the average value in only the visible cells. |
| AVERAGEIFSVISIBLE | Returns the average value in a list or array of numbers that satisfies multiple conditions. |
| MAXVISIBLE | Returns the largest value in only the visible cells. |
| MAXIFSVISIBLE | Returns the largest value in a list or array of numbers that satisfies multiple conditions. |
| MINVISIBLE | Returns the smallest value in only the visible cells. |
| MINIFSVISIBLE | Returns the smallest value in a list or array of numbers that satisfies multiple conditions. |
| WEIGHTEDAVERAGE | Returns the weighted average by multiplying each data point by a different weight. |
| AVERAGEVISIBLE Returns the average value in only the visible cells. |
| AVERAGEIFSVISIBLE Returns the average value in a list or array of numbers that satisfies multiple conditions. |
| MAXVISIBLE Returns the largest value in only the visible cells. |
| MAXIFSVISIBLE Returns the largest value in a list or array of numbers that satisfies multiple conditions. |
| MINVISIBLE Returns the smallest value in only the visible cells. |
| MINIFSVISIBLE Returns the smallest value in a list or array of numbers that satisfies multiple conditions. |
| WEIGHTEDAVERAGE Returns the weighted average by multiplying each data point by a different weight. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext
