Maths Functions

AVERAGEVISIBLEReturns the average value in only the visible cells.
AVERAGEIFSVISIBLEReturns the average value in a list or array of numbers that satisfies multiple conditions.
MAXVISIBLEReturns the largest value in only the visible cells.
MAXIFSVISIBLEReturns the largest value in a list or array of numbers that satisfies multiple conditions.
MINVISIBLEReturns the smallest value in only the visible cells.
MINIFSVISIBLEReturns the smallest value in a list or array of numbers that satisfies multiple conditions.
WEIGHTEDAVERAGEReturns 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