Maths Functions

AVERAGEVISIBLEReturns the average value in only the visible cells.
AVERAGEVISIBLEIFSReturns the average value in a list or array of numbers that satisfies multiple conditions.
MAXVISIBLEReturns the largest value in only the visible cells.
MAXVISIBLEIFSReturns the largest value in a list or array of numbers that satisfies multiple conditions.
MINVISIBLEReturns the smallest value in only the visible cells.
MINVISIBLEIFSReturns the smallest value in a list or array of numbers that satisfies multiple conditions.
AVERAGEVISIBLE
Returns the average value in only the visible cells.
AVERAGEVISIBLEIFS
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.
MAXVISIBLEIFS
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.
MINVISIBLEIFS
Returns the smallest value in a list or array of numbers that satisfies multiple conditions.

© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext